VIEW: APPS.IEX_CUSTOMER_TRX_PARTIAL_V

Source

View Text - Preformatted

SELECT CT.CUSTOMER_TRX_ID customer_trx_id , CT.TRX_NUMBER trx_number , CT.TRX_DATE trx_date , ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE) term_due_date , CT.TERM_ID term_id , CT.PURCHASE_ORDER purchase_order , CT.SHIP_DATE_ACTUAL ship_date_actual , RAC_BILL_PARTY.PARTY_NAME rac_bill_to_customer_name , RAC_BILL.ACCOUNT_NUMBER rac_bill_to_customer_num , RAA_BILL_LOC.ADDRESS1 raa_bill_to_address1 , RAA_BILL_LOC.ADDRESS2 raa_bill_to_address2 , RAA_BILL_LOC.ADDRESS3 raa_bill_to_address3_db , RAA_BILL_LOC.CITY raa_bill_to_city , RAA_BILL_LOC.STATE raa_bill_to_state , RAA_BILL_LOC.POSTAL_CODE raa_bill_to_postal_code , RAC_SHIP_PARTY.PARTY_NAME rac_ship_to_customer_name , RAA_SHIP_LOC.ADDRESS1 raa_ship_to_address1 , RAA_SHIP_LOC.ADDRESS2 raa_ship_to_address2 , RAA_SHIP_LOC.ADDRESS3 raa_ship_to_address3_db , RAA_SHIP_LOC.CITY raa_ship_to_city , RAA_SHIP_LOC.STATE raa_ship_to_state , RAA_SHIP_LOC.POSTAL_CODE raa_ship_to_postal_code , RAA_REMIT_LOC.ADDRESS1 raa_remit_to_address1 , RAA_REMIT_LOC.ADDRESS2 raa_remit_to_address2 , RAA_REMIT_LOC.ADDRESS3 raa_remit_to_address3_db , RAA_REMIT_LOC.CITY RAA_REMIT_TO_CITY , RAA_REMIT_LOC.STATE RAA_REMIT_TO_state , RAA_REMIT_LOC.POSTAL_CODE RAA_REMIT_TO_postal_code FROM RA_CUSTOMER_TRX CT , HZ_CUST_ACCOUNTS RAC_BILL , HZ_PARTIES RAC_BILL_PARTY , HZ_LOCATIONS RAA_BILL_LOC , HZ_PARTIES RAC_SHIP_PARTY , HZ_LOCATIONS RAA_SHIP_LOC , HZ_LOCATIONS RAA_REMIT_LOC , HZ_CUST_ACCOUNTS RAC_SHIP , HZ_CUST_ACCT_SITES RAA_BILL , HZ_CUST_SITE_USES_ALL SU_BILL , HZ_CUST_SITE_USES_ALL SU_SHIP , HZ_PARTY_SITES RAA_BILL_PS , HZ_CUST_ACCT_SITES RAA_SHIP , HZ_PARTY_SITES RAA_SHIP_PS , HZ_CUST_ACCT_SITES RAA_REMIT , HZ_PARTY_SITES RAA_REMIT_PS WHERE CT.BILL_TO_CUSTOMER_ID = RAC_BILL.CUST_ACCOUNT_ID AND RAC_BILL.PARTY_ID = RAC_BILL_PARTY.PARTY_ID AND CT.SHIP_TO_CUSTOMER_ID = RAC_SHIP.CUST_ACCOUNT_ID(+) AND RAC_SHIP.PARTY_ID = RAC_SHIP_PARTY.PARTY_ID(+) AND CT.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID AND CT.SHIP_TO_SITE_USE_ID = SU_SHIP.SITE_USE_ID(+) AND SU_BILL.CUST_ACCT_SITE_ID = RAA_BILL.CUST_ACCT_SITE_ID AND RAA_BILL.PARTY_SITE_ID = RAA_BILL_PS.PARTY_SITE_ID AND RAA_BILL_LOC.LOCATION_ID = RAA_BILL_PS.LOCATION_ID AND SU_SHIP.CUST_ACCT_SITE_ID = RAA_SHIP.CUST_ACCT_SITE_ID(+) AND RAA_SHIP.PARTY_SITE_ID = RAA_SHIP_PS.PARTY_SITE_ID(+) AND RAA_SHIP_LOC.LOCATION_ID(+) = RAA_SHIP_PS.LOCATION_ID AND CT.REMIT_TO_ADDRESS_ID = RAA_REMIT.CUST_ACCT_SITE_ID(+) AND RAA_REMIT.PARTY_SITE_ID = RAA_REMIT_PS.PARTY_SITE_ID(+) AND RAA_REMIT_LOC.LOCATION_ID(+) = RAA_REMIT_PS.LOCATION_ID

View Text - HTML Formatted

SELECT CT.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CT.TRX_NUMBER TRX_NUMBER
, CT.TRX_DATE TRX_DATE
, ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID
, CT.TERM_ID
, CT.TRX_DATE) TERM_DUE_DATE
, CT.TERM_ID TERM_ID
, CT.PURCHASE_ORDER PURCHASE_ORDER
, CT.SHIP_DATE_ACTUAL SHIP_DATE_ACTUAL
, RAC_BILL_PARTY.PARTY_NAME RAC_BILL_TO_CUSTOMER_NAME
, RAC_BILL.ACCOUNT_NUMBER RAC_BILL_TO_CUSTOMER_NUM
, RAA_BILL_LOC.ADDRESS1 RAA_BILL_TO_ADDRESS1
, RAA_BILL_LOC.ADDRESS2 RAA_BILL_TO_ADDRESS2
, RAA_BILL_LOC.ADDRESS3 RAA_BILL_TO_ADDRESS3_DB
, RAA_BILL_LOC.CITY RAA_BILL_TO_CITY
, RAA_BILL_LOC.STATE RAA_BILL_TO_STATE
, RAA_BILL_LOC.POSTAL_CODE RAA_BILL_TO_POSTAL_CODE
, RAC_SHIP_PARTY.PARTY_NAME RAC_SHIP_TO_CUSTOMER_NAME
, RAA_SHIP_LOC.ADDRESS1 RAA_SHIP_TO_ADDRESS1
, RAA_SHIP_LOC.ADDRESS2 RAA_SHIP_TO_ADDRESS2
, RAA_SHIP_LOC.ADDRESS3 RAA_SHIP_TO_ADDRESS3_DB
, RAA_SHIP_LOC.CITY RAA_SHIP_TO_CITY
, RAA_SHIP_LOC.STATE RAA_SHIP_TO_STATE
, RAA_SHIP_LOC.POSTAL_CODE RAA_SHIP_TO_POSTAL_CODE
, RAA_REMIT_LOC.ADDRESS1 RAA_REMIT_TO_ADDRESS1
, RAA_REMIT_LOC.ADDRESS2 RAA_REMIT_TO_ADDRESS2
, RAA_REMIT_LOC.ADDRESS3 RAA_REMIT_TO_ADDRESS3_DB
, RAA_REMIT_LOC.CITY RAA_REMIT_TO_CITY
, RAA_REMIT_LOC.STATE RAA_REMIT_TO_STATE
, RAA_REMIT_LOC.POSTAL_CODE RAA_REMIT_TO_POSTAL_CODE
FROM RA_CUSTOMER_TRX CT
, HZ_CUST_ACCOUNTS RAC_BILL
, HZ_PARTIES RAC_BILL_PARTY
, HZ_LOCATIONS RAA_BILL_LOC
, HZ_PARTIES RAC_SHIP_PARTY
, HZ_LOCATIONS RAA_SHIP_LOC
, HZ_LOCATIONS RAA_REMIT_LOC
, HZ_CUST_ACCOUNTS RAC_SHIP
, HZ_CUST_ACCT_SITES RAA_BILL
, HZ_CUST_SITE_USES_ALL SU_BILL
, HZ_CUST_SITE_USES_ALL SU_SHIP
, HZ_PARTY_SITES RAA_BILL_PS
, HZ_CUST_ACCT_SITES RAA_SHIP
, HZ_PARTY_SITES RAA_SHIP_PS
, HZ_CUST_ACCT_SITES RAA_REMIT
, HZ_PARTY_SITES RAA_REMIT_PS
WHERE CT.BILL_TO_CUSTOMER_ID = RAC_BILL.CUST_ACCOUNT_ID
AND RAC_BILL.PARTY_ID = RAC_BILL_PARTY.PARTY_ID
AND CT.SHIP_TO_CUSTOMER_ID = RAC_SHIP.CUST_ACCOUNT_ID(+)
AND RAC_SHIP.PARTY_ID = RAC_SHIP_PARTY.PARTY_ID(+)
AND CT.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID
AND CT.SHIP_TO_SITE_USE_ID = SU_SHIP.SITE_USE_ID(+)
AND SU_BILL.CUST_ACCT_SITE_ID = RAA_BILL.CUST_ACCT_SITE_ID
AND RAA_BILL.PARTY_SITE_ID = RAA_BILL_PS.PARTY_SITE_ID
AND RAA_BILL_LOC.LOCATION_ID = RAA_BILL_PS.LOCATION_ID
AND SU_SHIP.CUST_ACCT_SITE_ID = RAA_SHIP.CUST_ACCT_SITE_ID(+)
AND RAA_SHIP.PARTY_SITE_ID = RAA_SHIP_PS.PARTY_SITE_ID(+)
AND RAA_SHIP_LOC.LOCATION_ID(+) = RAA_SHIP_PS.LOCATION_ID
AND CT.REMIT_TO_ADDRESS_ID = RAA_REMIT.CUST_ACCT_SITE_ID(+)
AND RAA_REMIT.PARTY_SITE_ID = RAA_REMIT_PS.PARTY_SITE_ID(+)
AND RAA_REMIT_LOC.LOCATION_ID(+) = RAA_REMIT_PS.LOCATION_ID