TRX_NUMBER Throug will get customer detail and order details in oracle apps R12.1.3

 Accounts Recevibles Based on TRX_NUMBER, through will get customer detail and order details in oracle apps R12.1.3


SELECT   hp.party_id,
         hp.party_number,
         hp.party_name,
         hp.status active,
         hp.address1 address1,
         hp.address2 address2,
         hp.city     city,
         hp.county   county,
         hp.country  country,
         hp.postal_code postalcode,
         rcta.trx_number,
         rctta.name,
         apsca.trx_date
FROM     HZ_PARTIES HP,
                 HZ_CUST_ACCOUNTS_ALL HCAA,
                 HZ_CUST_ACCT_SITES_ALL HCASA,
                  RA_CUSTOMER_TRX_ALL RCTA,
                   RA_CUST_TRX_TYPES_ALL RCTTA,
                  AR_PAYMENT_SCHEDULES_ALL APSCA
WHERE    hp.party_id = hcaa.party_id
AND      hcaa.cust_account_id = hcasa.cust_account_id
AND      hcaa.cust_account_id = rcta.bill_to_customer_id
AND      rcta.cust_trx_type_id = rctta.cust_trx_type_id
AND      apsca.customer_trx_id = rcta.customer_trx_id
AND      hcaa.party_id ='1048'
AND      rcta.trx_number ='2428'