DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on HZ_CUST_ACCOUNTS

Line 1682: FROM hz_cust_accounts bill_to_cust,

1678: rct.bill_to_customer_id,
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

Line 1692: FROM hz_cust_accounts ship_to_cust,

1688:
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