DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 64: hz_cust_accounts hca

60: p_end_date IN DATE) IS
61: SELECT oola.sold_to_org_id customer_id
62: FROM oe_order_headers_all ooha,
63: oe_order_lines_all oola,
64: hz_cust_accounts hca
65: WHERE ooha.header_id = oola.header_id
66: AND ooha.org_id = oola.org_id
67: AND ooha.org_id = p_org_id
68: AND oola.inventory_item_id = p_inventory_item_id