DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on HZ_CUST_ACCOUNTS

Line 782: from hz_cust_accounts bill_to_cust,

778: rct.trx_number
779: into p_bill_to_site_use_id, p_customer_id,
780: p_bill_to_customer_name, p_bill_to_customer_number,
781: p_trx_number
782: from hz_cust_accounts bill_to_cust,
783: hz_parties party,
784: ra_customer_trx rct
785: where rct.customer_trx_id = p_customer_trx_id
786: and rct.bill_to_customer_id = bill_to_cust.cust_account_id

Line 809: from hz_cust_accounts ship_to_cust,

805: select substrb(party.party_name,1,50),
806: ship_to_cust.account_number
807: into p_ship_to_customer_name,
808: p_ship_to_customer_number
809: from hz_cust_accounts ship_to_cust,
810: hz_parties party,
811: ra_customer_trx rct
812: where rct.customer_trx_id = p_customer_trx_id
813: and rct.ship_to_customer_id = ship_to_cust.cust_account_id