VIEW: APPS.AR_OEX_INVOICE_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'