eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMSELECTION_PVT dependencies on HZ_PARTIES

Line 996: l_where_clause := l_where_clause || ' AND hpr.directional_flag=''F'' AND hpr.subject_table_name = ''HZ_PARTIES''';

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;
995: END IF;
996: l_where_clause := l_where_clause || ' AND hpr.directional_flag=''F'' AND hpr.subject_table_name = ''HZ_PARTIES''';
997: l_where_clause := l_where_clause || ' AND hpr.object_table_name = ''HZ_PARTIES'' AND hpr.directional_flag = ''F''';
998: l_where_clause := l_where_clause || ' AND hpr.relationship_code IN (''CONTACT_OF'' , ''EMPLOYEE_OF'')';
999: END IF;
1000:

Line 997: l_where_clause := l_where_clause || ' AND hpr.object_table_name = ''HZ_PARTIES'' AND hpr.directional_flag = ''F''';

993: ELSE
994: l_where_clause :=' hpr.party_id='|| l_pk_field;
995: END IF;
996: l_where_clause := l_where_clause || ' AND hpr.directional_flag=''F'' AND hpr.subject_table_name = ''HZ_PARTIES''';
997: l_where_clause := l_where_clause || ' AND hpr.object_table_name = ''HZ_PARTIES'' AND hpr.directional_flag = ''F''';
998: l_where_clause := l_where_clause || ' AND hpr.relationship_code IN (''CONTACT_OF'' , ''EMPLOYEE_OF'')';
999: END IF;
1000:
1001: l_sql_statement := l_insert_clause || l_insert_fields ||

Line 1576: -- FROM ams_dm_target_stg t, HZ_PARTIES p

1572: , t.party_id
1573: , 'N'
1574: , NULL
1575: , DECODE (t.target_flag, 'Y', l_target_value, '0')
1576: -- FROM ams_dm_target_stg t, HZ_PARTIES p
1577: FROM ams_dm_target_stg_gt t, HZ_PARTIES p
1578: WHERE t.arc_object_used_by = p_arc_object_for
1579: AND t.object_used_by_id = p_object_for_id
1580: AND t.arc_object = l_sources_rec.arc_incl_object_from

Line 1577: FROM ams_dm_target_stg_gt t, HZ_PARTIES p

1573: , 'N'
1574: , NULL
1575: , DECODE (t.target_flag, 'Y', l_target_value, '0')
1576: -- FROM ams_dm_target_stg t, HZ_PARTIES p
1577: FROM ams_dm_target_stg_gt t, HZ_PARTIES p
1578: WHERE t.arc_object_used_by = p_arc_object_for
1579: AND t.object_used_by_id = p_object_for_id
1580: AND t.arc_object = l_sources_rec.arc_incl_object_from
1581: AND t.object_id = l_sources_rec.incl_object_id

Line 1606: -- FROM ams_dm_target_stg t , HZ_PARTIES p

1602: , t.party_id
1603: , 'N'
1604: , NULL
1605: , DECODE (t.target_flag, 'Y', l_target_value, '0')
1606: -- FROM ams_dm_target_stg t , HZ_PARTIES p
1607: FROM ams_dm_target_stg_gt t , HZ_PARTIES p
1608: WHERE t.arc_object_used_by = p_arc_object_for
1609: AND t.object_used_by_id = p_object_for_id
1610: AND t.arc_object = l_sources_rec.arc_incl_object_from

Line 1607: FROM ams_dm_target_stg_gt t , HZ_PARTIES p

1603: , 'N'
1604: , NULL
1605: , DECODE (t.target_flag, 'Y', l_target_value, '0')
1606: -- FROM ams_dm_target_stg t , HZ_PARTIES p
1607: FROM ams_dm_target_stg_gt t , HZ_PARTIES p
1608: WHERE t.arc_object_used_by = p_arc_object_for
1609: AND t.object_used_by_id = p_object_for_id
1610: AND t.arc_object = l_sources_rec.arc_incl_object_from
1611: AND t.object_id = l_sources_rec.incl_object_id

Line 2002: AND hpr.subject_table_name = 'HZ_PARTIES'

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'
2004: AND hpr.directional_flag = 'F'
2005: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2006: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2003: AND hpr.object_table_name = 'HZ_PARTIES'

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'
2004: AND hpr.directional_flag = 'F'
2005: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2006: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2007: AND p.party_id = hpr.object_id --the org's party id

Line 2166: and hpr.subject_table_name = 'HZ_PARTIES'

2162: and oh.SHIP_TO_CONTACT_ID = hcr.CUST_ACCOUNT_ROLE_ID
2163: and hcr.PARTY_ID=hpr.PARTY_ID
2164: and hpr.party_id = t.party_id
2165: and hpr.status = 'A'
2166: and hpr.subject_table_name = 'HZ_PARTIES'
2167: and hpr.object_table_name = 'HZ_PARTIES'
2168: and hpr.directional_flag = 'F'
2169: and hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')
2170: and (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2167: and hpr.object_table_name = 'HZ_PARTIES'

2163: and hcr.PARTY_ID=hpr.PARTY_ID
2164: and hpr.party_id = t.party_id
2165: and hpr.status = 'A'
2166: and hpr.subject_table_name = 'HZ_PARTIES'
2167: and hpr.object_table_name = 'HZ_PARTIES'
2168: and hpr.directional_flag = 'F'
2169: and hpr.relationship_code IN ('CONTACT_OF','EMPLOYEE_OF')
2170: and (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2171: and oh.header_id = ol.header_id