DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on HZ_CUST_ACCOUNTS

Line 1641: FROM hz_cust_accounts bill_to_cust,

1637: rct.bill_to_customer_id,
1638: substrb(party.party_name,1,50),
1639: bill_to_cust.account_number,
1640: rct.trx_number
1641: FROM hz_cust_accounts bill_to_cust,
1642: hz_parties party,
1643: ra_customer_trx rct
1644: WHERE rct.customer_trx_id = p_customer_trx_id
1645: AND rct.bill_to_customer_id = bill_to_cust.cust_account_id

Line 1651: FROM hz_cust_accounts ship_to_cust,

1647:
1648: CURSOR c2 IS
1649: SELECT substrb(party.party_name,1,50),
1650: ship_to_cust.account_number
1651: FROM hz_cust_accounts ship_to_cust,
1652: hz_parties party,
1653: ra_customer_trx rct
1654: WHERE rct.customer_trx_id = p_customer_trx_id
1655: AND rct.ship_to_customer_id = ship_to_cust.cust_account_id