AP_UNAPPLY_PREPAYS_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 PREPAY_NUMBER VENDOR_ID VENDOR_SITE_ID PO_NUMBER VENDOR_SITE_CODE 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) 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 PREPAY_NUMBER, AI.VENDOR_ID VENDOR_ID, AI.VENDOR_SITE_ID VENDOR_SITE_ID, PH.SEGMENT1 PO_NUMBER, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE FROM AP_INVOICES_ALL AI, AP_INVOICE_LINES AIL, POZ_SUPPLIER_SITES_ALL_M PVS, PO_HEADERS_ALL PH WHERE AI.INVOICE_ID = AIL.PREPAY_INVOICE_ID AND AIL.AMOUNT < 0 AND NVL(AIL.DISCARDED_FLAG,'N') <> 'Y' AND AIL.LINE_TYPE_LOOKUP_CODE = 'PREPAY' 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 (+)