View: AP_DIST_PREPAY_APPLICATION_V

Product:	AP - Payables
Description:	Internal view
Implementation/DBA Data:	APPS.AP_DIST_PREPAY_APPLICATION_V

View Text

SELECT AID.ROWID ROW_ID
, AID.INVOICE_ID INVOICE_ID
, AID.INVOICE_LINE_NUMBER PREPAY_LINE_NUMBER
, AID.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, AID.DISTRIBUTION_LINE_NUMBER PREPAY_DIST_NUMBER
, (NVL(AID.PREPAY_AMOUNT_REMAINING
, AID.TOTAL_DIST_AMOUNT) + AP_PREPAY_UTILS_PKG.GET_DIST_INCLUSIVE_TAX_AMT( AID.INVOICE_ID
, AID.INVOICE_LINE_NUMBER
, AID.INVOICE_DISTRIBUTION_ID)) PREPAY_AMOUNT_REMAINING
, NULLIF(AP_PREPAY_UTILS_PKG.GET_DIST_INCLUSIVE_TAX_AMT( AID.INVOICE_ID
, AID.INVOICE_LINE_NUMBER
, AID.INVOICE_DISTRIBUTION_ID)
, 0) TAX_AMOUNT_REMAINING
, AID.DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, AID.TOTAL_DIST_AMOUNT AMOUNT
, AID.TOTAL_DIST_BASE_AMOUNT BASE_AMOUNT
, AID.QUANTITY_INVOICED QUANTITY_INVOICED
, AID.STAT_AMOUNT STAT_AMOUNT
, AID.PA_QUANTITY PA_QUANTITY
, AID.ACCOUNTING_DATE ACCOUNTING_DATE
, AID.PERIOD_NAME PERIOD_NAME
, AID.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AID.DESCRIPTION DESCRIPTION
, AID.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, AID.RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, AID.ORG_ID ORG_ID
FROM AP_INVOICE_DISTRIBUTIONS AID
WHERE AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM'
, 'ACCRUAL')
AND NVL(AID.PREPAY_AMOUNT_REMAINING
, AID.TOTAL_DIST_AMOUNT) + AP_PREPAY_UTILS_PKG.GET_DIST_INCLUSIVE_TAX_AMT( AID.INVOICE_ID
, AID.INVOICE_LINE_NUMBER
, AID.INVOICE_DISTRIBUTION_ID) > 0
AND NVL(AID.REVERSAL_FLAG
, 'N') <> 'Y'

Columns