1. Tables and Views for Financials
  2. AP_PREPAY_APPLICATIONS_V

AP_PREPAY_APPLICATIONS_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

INVOICE_ID

INVOICE_LINE_NUMBER

PREPAY_INVOICE_ID

PREPAY_LINE_NUMBER

PREPAY_AMOUNT_APPLIED

TAX_AMOUNT_APPLIED

PREPAY_AMOUNT_REMAINING

ACCOUNTING_DATE

PERIOD_NAME

SET_OF_BOOKS_ID

DESCRIPTION

INVOICE_INCLUDES_PREPAY_FLAG

PO_LINE_LOCATION_ID

PO_DISTRIBUTION_ID

RCV_TRANSACTION_ID

ORG_ID

INVOICE_NUMBER

VENDOR_ID

VENDOR_SITE_ID

PO_NUMBER

VENDOR_SITE_CODE

RECEIPT_NUMBER

INVOICE_CURRENCY_CODE

Query

SQL_Statement

SELECT AIL.INVOICE_ID INVOICE_ID,

AIL.LINE_NUMBER INVOICE_LINE_NUMBER,

AIL.PREPAY_INVOICE_ID PREPAY_INVOICE_ID,

AIL.PREPAY_LINE_NUMBER PREPAY_LINE_NUMBER,

( -1)*(AIL.AMOUNT - NVL(AIL.INCLUDED_TAX_AMOUNT,0)) PREPAY_AMOUNT_APPLIED,

NULLIF((-1)*(NVL(AIL.TOTAL_REC_TAX_AMOUNT, 0) + NVL(AIL.TOTAL_NREC_TAX_AMOUNT, 0)), 0) TAX_AMOUNT_APPLIED,

AP_PREPAY_UTILS_PKG.GET_LINE_PREPAY_AMT_REMAINING (AIL.PREPAY_INVOICE_ID, AIL.PREPAY_LINE_NUMBER) PREPAY_AMOUNT_REMAINING,

AIL.ACCOUNTING_DATE ACCOUNTING_DATE,

AIL.PERIOD_NAME PERIOD_NAME,

AIL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID,

AIL.DESCRIPTION DESCRIPTION,

AIL.INVOICE_INCLUDES_PREPAY_FLAG INVOICE_INCLUDES_PREPAY_FLAG,

AIL.PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID,

AIL.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID,

AIL.RCV_TRANSACTION_ID RCV_TRANSACTION_ID,

AIL.ORG_ID ORG_ID,

AI.INVOICE_NUM INVOICE_NUMBER,

AI.VENDOR_ID VENDOR_ID,

AI.VENDOR_SITE_ID VENDOR_SITE_ID,

PH.SEGMENT1 PO_NUMBER,

PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE,

RSH.RECEIPT_NUM RECEIPT_NUMBER,

AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE

FROM ap_invoices_all ai,

ap_invoice_lines_all ail,

POZ_SUPPLIER_SITES_ALL_M PVS,

PO_HEADERS_ALL PH,

PO_LINE_LOCATIONS_ALL PLL,

RCV_TRANSACTIONS RTXNS,

RCV_SHIPMENT_HEADERS RSH,

RCV_SHIPMENT_LINES RSL

WHERE ai.invoice_id = ail.invoice_id

AND AI.VENDOR_ID = PVS.VENDOR_ID

AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID

AND AIL.PO_HEADER_ID = PH.PO_HEADER_ID (+)

AND AIL.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)

AND AIL.RCV_TRANSACTION_ID = RTXNS.TRANSACTION_ID (+)

AND RTXNS.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID (+)

AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID (+)

AND ail.prepay_invoice_id IS NOT NULL

AND ail.amount <0

AND NVL(AIL.DISCARDED_FLAG,'N') <> 'Y'