View: AP_INVOICE_PRICE_VAR_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_INVOICE_PRICE_VAR_V

View Text

SELECT API.INVOICE_NUM INVOICE_NUM
, API.INVOICE_DATE INVOICE_DATE /*13682517*/
, AID.QUANTITY_INVOICED
, API.EXCHANGE_RATE INVOICE_RATE /*13682517*/
, AID.AMOUNT INVOICE_AMOUNT /*REQ. IS DIST AMT */
, AID.BASE_AMOUNT INVOICE_BASE_AMOUNT /*REQ. IS DIST BASE AMT */
, AID.UNIT_PRICE INVOICE_PRICE
, API.INVOICE_CURRENCY_CODE INVOICE_CURRENCY /*
, AID.INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE*/
, NVL(AIDIPV.AMOUNT
, 0) INVOICE_PRICE_VARIANCE /*13682517*/
, NVL(AIDIPV.BASE_AMOUNT
, 0) BASE_INV_PRICE_VAR /*13682517*/ /* BUG 12691324 */
, NVL(AIDERV.BASE_AMOUNT
, 0) EX_RATE_VARI
, AID.PO_DISTRIBUTION_ID
, AID.RCV_TRANSACTION_ID
, AID.ACCOUNTING_DATE FROM AP_INVOICES API
, AP_INVOICE_DISTRIBUTIONS AID
, AP_INVOICE_DISTRIBUTIONS AIDIPV
, AP_INVOICE_DISTRIBUTIONS AIDERV WHERE API.INVOICE_ID = AID.INVOICE_ID AND AIDIPV.POSTED_FLAG(+) ||'' = 'Y' AND AIDERV.POSTED_FLAG(+) ||'' = 'Y' AND AID.LINE_TYPE_LOOKUP_CODE IN ( 'ITEM'
, 'ACCRUAL' ) AND AIDIPV.RELATED_ID(+) = AID.INVOICE_DISTRIBUTION_ID AND AIDIPV.LINE_TYPE_LOOKUP_CODE(+) = 'IPV' AND AIDERV.RELATED_ID(+) = AID.INVOICE_DISTRIBUTION_ID AND AIDERV.LINE_TYPE_LOOKUP_CODE(+) = 'ERV' /* BUG 12691324 */ AND (AIDERV.BASE_AMOUNT IS NOT NULL OR AIDIPV.AMOUNT IS NOT NULL ) UNION ALL /* FOR PRICE CORRECTION INVOICES */ SELECT API.INVOICE_NUM INVOICE_NUM
, API.INVOICE_DATE INVOICE_DATE /*13682517*/
, AID.QUANTITY_INVOICED
, API.EXCHANGE_RATE INVOICE_RATE /*13682517*/
, AID.AMOUNT INVOICE_AMOUNT
, AID.BASE_AMOUNT INVOICE_BASE_AMOUNT
, AID.UNIT_PRICE INVOICE_PRICE
, API.INVOICE_CURRENCY_CODE INVOICE_CURRENCY /*
, AID.INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE*/
, NVL(AIDIPV.AMOUNT
, 0) INVOICE_PRICE_VARIANCE /*13682517*/
, NVL(AIDIPV.BASE_AMOUNT
, 0) BASE_INV_PRICE_VAR /*13682517*/
, NVL(AIDERV.BASE_AMOUNT
, 0) EX_RATE_VARI /*13682517*/
, AID.PO_DISTRIBUTION_ID
, AID.RCV_TRANSACTION_ID
, AID.ACCOUNTING_DATE /*13682517*/ FROM AP_INVOICES API
, AP_INVOICE_DISTRIBUTIONS AID
, AP_INVOICE_DISTRIBUTIONS AIDIPV
, AP_INVOICE_DISTRIBUTIONS AIDERV /*13682517*/ WHERE API.INVOICE_ID = AID.INVOICE_ID AND AIDIPV.POSTED_FLAG ||'' = 'Y' AND AIDERV.POSTED_FLAG(+) ||'' = 'Y' /*13682517*/ AND AID.LINE_TYPE_LOOKUP_CODE IN ( 'ITEM'
, 'ACCRUAL' ) AND AIDIPV.CORRECTED_INVOICE_DIST_ID = AID.INVOICE_DISTRIBUTION_ID AND AIDIPV.LINE_TYPE_LOOKUP_CODE = 'IPV' /*13682517*/ AND AIDERV.RELATED_ID(+) = AIDIPV.INVOICE_DISTRIBUTION_ID AND AIDERV.LINE_TYPE_LOOKUP_CODE(+) = 'ERV' AND (AIDERV.BASE_AMOUNT IS NOT NULL OR AIDIPV.AMOUNT IS NOT NULL)