APPS.AP_INVOICES_DERIVED_V
[Home] [Help]
| Product: | AP - Payables |
|---|---|
| Description: | (Release 10SC Only) |
| Implementation/DBA Data: |
APPS.AP_INVOICES_DERIVED_V
|
SELECT AI.ROWID ROW_ID
, AI.INVOICE_AMOUNT INVOICE_AMOUNT
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE_LOOKUP_CODE
, AI.PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG
, AI.CANCELLED_BY CANCELLED_BY
, NVL(AP_INVOICES_PKG.GET_DISTRIBUTION_TOTAL( AI.INVOICE_ID)
, 0) DISTRIBUTION_TOTAL
, AP_INVOICES_PKG.GET_POSTING_STATUS( AI.INVOICE_ID) POSTING_FLAG
, AP_INVOICES_PKG.GET_APPROVAL_STATUS( AI.INVOICE_ID
, AI.INVOICE_AMOUNT
, AI.PAYMENT_STATUS_FLAG
, AI.INVOICE_TYPE_LOOKUP_CODE) APPROVAL_STATUS_LOOKUP_CODE
, AP_INVOICES_PKG.GET_PO_NUMBER( AI.INVOICE_ID) PO_NUMBER
, AP_INVOICES_PKG.GET_AMOUNT_WITHHELD( AI.INVOICE_ID) AMOUNT_WITHHELD
, AP_INVOICES_PKG.GET_NOTES_COUNT( AI.INVOICE_ID) NOTES_COUNT
, AP_INVOICES_PKG.GET_HOLDS_COUNT( AI.INVOICE_ID) HOLDS_COUNT
, AP_INVOICES_PKG.GET_AMOUNT_HOLD_FLAG( AI.INVOICE_ID) AMOUNT_HOLD_FLAG
, AP_INVOICES_PKG.GET_VENDOR_HOLD_FLAG( AI.INVOICE_ID) VENDOR_HOLD_FLAG
, AP_INVOICES_PKG.GET_TOTAL_PREPAYS( AI.VENDOR_ID
, AI.ORG_ID) TOTAL_PREPAYS
, AP_INVOICES_PKG.GET_AVAILABLE_PREPAYS( AI.VENDOR_ID
, AI.ORG_ID) AVAILABLE_PREPAYS
, AP_INVOICES_PKG.GET_ENCUMBERED_FLAG( AI.INVOICE_ID) ENCUMBERED_FLAG
, AI.GL_DATE GL_DATE
, AP_UTILITIES_PKG.GET_GL_PERIOD_NAME(AI.GL_DATE
, AI.ORG_ID) PERIOD_NAME
, AP_INVOICES_PKG.SELECTED_FOR_PAYMENT_FLAG( AI.INVOICE_ID) SELECTED_FOR_PAYMENT_FLAG
, AP_INVOICES_PKG.GET_UNPOSTED_VOID_PAYMENT ( AI.INVOICE_ID) UNPOSTED_VOID_PAYMENT_FLAG
, AP_INVOICES_PKG.GET_DISCOUNT_PAY_DISTS_FLAG ( AI.INVOICE_ID) DISCOUNT_PAY_DISTS_FLAG
, AP_INVOICES_PKG.GET_PREPAYMENTS_APPLIED_FLAG ( AI.INVOICE_ID) PREPAYMENTS_APPLIED_FLAG
, AP_INVOICES_PKG.GET_PAYMENTS_EXIST_FLAG ( AI.INVOICE_ID) PAYMENTS_EXIST_FLAG
, AP_INVOICES_PKG.GET_PACKET_ID ( AI.INVOICE_ID) QUERY_PACKET_ID
, DECODE(AI.INVOICE_TYPE_LOOKUP_CODE
, 'PREPAYMENT'
, AP_INVOICES_PKG.GET_PREPAY_AMOUNT_APPLIED ( AI.INVOICE_ID)
, 0) PREPAY_AMOUNT_APPLIED
, FND_USER_AP_PKG.GET_USER_NAME( AI.CANCELLED_BY) CANCELLED_BY_DISPLAY
, AP_INVOICES_UTILITY_PKG.GET_MAX_INV_LINE_NUM( AI.INVOICE_ID) HIGHEST_LINE_NUM
, NVL(AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL( AI.INVOICE_ID)
, 0) LINE_TOTAL
, AI.ORG_ID
FROM AP_INVOICES AI