Product: | AR - Receivables |
---|---|
Description: | (Invoice view for Oracle Exchange Invoices) |
Implementation/DBA Data: | APPS.AR_OEX_INVOICE_VIEW |
SELECT PS.ORG_ID
, PS.TRX_NUMBER
, PS.TRX_DATE
, PS.TERMS_SEQUENCE_NUMBER
, PS.INVOICE_CURRENCY_CODE
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID
, PS.CLASS
, PS.STATUS
, CT.PURCHASE_ORDER
, CT.PREVIOUS_CUSTOMER_TRX_ID
, PS.DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, AL_CLASS.MEANING
, AL_STATUS.MEANING
, CT.INTERFACE_HEADER_CONTEXT
, CT.INTERFACE_HEADER_ATTRIBUTE1
, CT.INTERFACE_HEADER_ATTRIBUTE2
, CT.INTERFACE_HEADER_ATTRIBUTE3
, CT.INTERFACE_HEADER_ATTRIBUTE4
FROM /* SHIV RAGUNAT 10/10/96 ADDED THE FOLLOWING 3 TABLES TO GET */ /* THE FUNCTIONAL CURRENCY FOR FUNCTIONAL AMOUNT CALCULATION */ AR_LOOKUPS AL_STATUS
, AR_LOOKUPS AL_CLASS
, RA_CUSTOMER_TRX_ALL CT
, HZ_CUST_SITE_USES_ALL SU
, AR_PAYMENT_SCHEDULES_ALL PS
WHERE CT.ORG_ID = SU.ORG_ID AND SU.ORG_ID = PS.ORG_ID AND PS.CUSTOMER_SITE_USE_ID = SU.SITE_USE_ID
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM' AND AL_CLASS.LOOKUP_CODE = 'INV'
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND PS.STATUS = AL_STATUS.LOOKUP_CODE
AND AL_STATUS.LOOKUP_TYPE = 'INVOICE_TRX_STATUS'