DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 63: hz_cust_accounts hca

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