DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on HZ_PARTIES

Line 1683: hz_parties party,

1679: substrb(party.party_name,1,50),
1680: bill_to_cust.account_number,
1681: rct.trx_number
1682: FROM hz_cust_accounts bill_to_cust,
1683: hz_parties party,
1684: ra_customer_trx rct
1685: WHERE rct.customer_trx_id = p_customer_trx_id
1686: AND rct.bill_to_customer_id = bill_to_cust.cust_account_id
1687: AND bill_to_cust.party_id = party.party_id ;

Line 1693: hz_parties party,

1689: CURSOR c2 IS
1690: SELECT substrb(party.party_name,1,50),
1691: ship_to_cust.account_number
1692: FROM hz_cust_accounts ship_to_cust,
1693: hz_parties party,
1694: ra_customer_trx rct
1695: WHERE rct.customer_trx_id = p_customer_trx_id
1696: AND rct.ship_to_customer_id = ship_to_cust.cust_account_id
1697: AND ship_to_cust.party_id = party.party_id;