APPS.AMS_DMSELECTION_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2152: hz_cust_account_roles hcr, hz_relationships hpr

2148: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2149: FROM dual
2150: WHERE EXISTS (SELECT 1
2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,
2152: hz_cust_account_roles hcr, hz_relationships hpr
2153: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2154: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2155: and ol.INVENTORY_ITEM_ID IN
2156: (SELECT DISTINCT ic.INVENTORY_ITEM_ID