View: AP_SLA_INVOICES_TRANSACTION_V

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

View Text

SELECT AI.INVOICE_ID
, HZP.PARTY_NAME
, HZPS.PARTY_SITE_NAME
, AI.INVOICE_NUM
, DECODE(AI.CANCELLED_DATE
, NULL
, AI.INVOICE_AMOUNT
, AI.CANCELLED_AMOUNT) INVOICE_AMOUNT
, /* BUG:7375417*/ ALC.DISPLAYED_FIELD PAYMENT_STATUS
, /* BUG 7039815 */ AI.BASE_AMOUNT
, AI.INVOICE_TYPE_LOOKUP_CODE
, AI.INVOICE_DATE
, AI.CANCELLED_DATE
, AI.DESCRIPTION
, AI.TERMS_DATE
, (SELECT ATL.DUE_DAYS
FROM AP_TERMS_LINES ATL
WHERE AI.TERMS_ID = ATL.TERM_ID
AND ROWNUM = 1 ) DUE_DAYS FROM AP_INVOICES_ALL AI
, HZ_PARTIES HZP
, HZ_PARTY_SITES HZPS
, AP_SUPPLIERS AS1
, AP_LOOKUP_CODES ALC /* BUG 7039815 */ WHERE AI.VENDOR_ID = AS1.VENDOR_ID(+) /* BUG 7019211
, 6150175 */ AND AI.PARTY_ID = HZP.PARTY_ID AND AI.PARTY_SITE_ID = HZPS.PARTY_SITE_ID(+) AND ( ( AS1.EMPLOYEE_ID IS NULL
AND HZPS.PARTY_SITE_ID IS NOT NULL) OR ( AS1.EMPLOYEE_ID IS NOT NULL)) AND ALC.LOOKUP_TYPE (+) = 'INVOICE PAYMENT STATUS' /* BUG 7039815 */ AND ALC.LOOKUP_CODE (+) = AI.PAYMENT_STATUS_FLAG /* BUG 7039815 */