DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on HZ_PARTIES

Line 824: hz_parties party,

820: into p_bill_to_site_use_id, p_customer_id,
821: p_bill_to_customer_name, p_bill_to_customer_number,
822: p_trx_number
823: from hz_cust_accounts bill_to_cust,
824: hz_parties party,
825: ra_customer_trx rct
826: where rct.customer_trx_id = p_customer_trx_id
827: and rct.bill_to_customer_id = bill_to_cust.cust_account_id
828: and bill_to_cust.party_id = party.party_id ;

Line 851: hz_parties party,

847: ship_to_cust.account_number
848: into p_ship_to_customer_name,
849: p_ship_to_customer_number
850: from hz_cust_accounts ship_to_cust,
851: hz_parties party,
852: ra_customer_trx rct
853: where rct.customer_trx_id = p_customer_trx_id
854: and rct.ship_to_customer_id = ship_to_cust.cust_account_id
855: and ship_to_cust.party_id = party.party_id;