APPS.DPP_UTILITY_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1523: ,hz_cust_accounts hca

1519: sum(decode(osta.transfer_type, 'IN', nvl(osta.common_quantity,0), 0)) - sum(decode(osta.transfer_type, 'OUT', nvl(osta.common_quantity,0), 0)) as end_inventory
1520: FROM
1521: ozf_sales_transactions_all osta
1522: ,hz_parties hp
1523: ,hz_cust_accounts hca
1524: WHERE osta.sold_to_party_id = hp.party_id
1525: AND osta.error_flag='N'
1526: AND osta.sold_to_party_id =hp.party_id
1527: AND hca.cust_account_id = p_customer_id

Line 1616: hz_cust_accounts hz,

1612: hz.account_number,
1613: hz.account_name
1614: FROM
1615: oe_order_lines_all oola,
1616: hz_cust_accounts hz,
1617: dpp_transaction_headers_all dtha,
1618: dpp_transaction_lines_all dtla
1619: WHERE
1620: oola.org_id = dtla.org_id and

Line 2225: hz_cust_accounts hz

2221: SELECT
2222: hz.account_number,
2223: hz.account_name
2224: FROM
2225: hz_cust_accounts hz
2226: WHERE
2227: hz.cust_account_id = p_customer_id;
2228: l_customer_tbl customer_tbl_type := p_customer_tbl;
2229: