VIEW: APPS.AP_DIST_PREPAY_APPLICATION_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'