APPS.AMS_DMSELECTION_PVT dependencies on HZ_RELATIONSHIPS

Line 990: l_from_clause :=l_from_clause || ',hz_relationships hpr';

986:
987: -- kbasavar For Customer Profitability
988: IF l_is_b2b AND l_model_type='CUSTOMER_PROFITABILITY' THEN
989: l_insert_fields := l_insert_fields || ', hpr.object_id ';
990: l_from_clause :=l_from_clause || ',hz_relationships hpr';
991: IF l_where_clause IS NOT NULL THEN
992: l_where_clause :=l_where_clause || ' AND hpr.party_id='|| l_pk_field;
993: ELSE
994: l_where_clause :=' hpr.party_id='|| l_pk_field;

Line 1999: FROM bic_party_summ p , hz_relationships hpr

1995: -- changed rosharma 19-jun-2003 bug # 3004453
1996: --FROM ams_dm_party_details_time p
1997: --WHERE p.party_id = t.party_id
1998: --AND p.tot_num_order_3_months < 1
1999: FROM bic_party_summ p , hz_relationships hpr
2000: WHERE hpr.party_id = t.party_id
2001: AND hpr.status = 'A'
2002: AND hpr.subject_table_name = 'HZ_PARTIES'
2003: AND hpr.object_table_name = 'HZ_PARTIES'

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