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_DMEXTRACT_PVT dependencies on HZ_PARTIES

Line 274: FROM hz_parties a

270: FROM ams_dm_party_details x
271: WHERE x.party_type = p_party_type
272: /* AND EXISTS (
273: (SELECT a.party_id
274: FROM hz_parties a
275: WHERE a.last_update_date > x.last_update_date
276: AND a.party_id = x.party_id
277: AND a.status = 'A')
278: UNION ALL

Line 288: AND c.subject_table_name = 'HZ_PARTIES'

284: UNION ALL
285: (SELECT c.party_id
286: FROM hz_relationships c
287: WHERE c.last_update_date > x.last_update_date
288: AND c.subject_table_name = 'HZ_PARTIES'
289: AND c.object_table_name = 'HZ_PARTIES'
290: AND c.directional_flag = 'F'
291: AND c.party_id = x.party_id
292: AND c.status = 'A' AND SYSDATE BETWEEN c.start_date AND NVL(c.end_date,SYSDATE))

Line 289: AND c.object_table_name = 'HZ_PARTIES'

285: (SELECT c.party_id
286: FROM hz_relationships c
287: WHERE c.last_update_date > x.last_update_date
288: AND c.subject_table_name = 'HZ_PARTIES'
289: AND c.object_table_name = 'HZ_PARTIES'
290: AND c.directional_flag = 'F'
291: AND c.party_id = x.party_id
292: AND c.status = 'A' AND SYSDATE BETWEEN c.start_date AND NVL(c.end_date,SYSDATE))
293: UNION ALL

Line 497: hz_parties hzp

493: FROM
494: -- ams_dm_drv_stg drv,
495: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
496: hz_organization_profiles hop,
497: hz_parties hzp
498: WHERE
499: drv.party_id = hzp.party_id
500: AND hzp.status = 'A'
501: AND hop.party_id(+) = hzp.party_id

Line 694: hz_parties hzp

690: hz_organization_profiles hop,
691: hz_org_contacts hoc,
692: hz_employment_history heh,
693: hz_relationships hpr,
694: hz_parties hzp
695: WHERE
696: drv.party_id = hzp.party_id
697: AND hzp.status = 'A'
698: AND drv.party_id = hpr.party_id

Line 700: AND hpr.subject_table_name = 'HZ_PARTIES'

696: drv.party_id = hzp.party_id
697: AND hzp.status = 'A'
698: AND drv.party_id = hpr.party_id
699: AND hpr.status = 'A'
700: AND hpr.subject_table_name = 'HZ_PARTIES'
701: AND hpr.object_table_name = 'HZ_PARTIES'
702: AND hpr.directional_flag = 'F'
703: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
704: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 701: AND hpr.object_table_name = 'HZ_PARTIES'

697: AND hzp.status = 'A'
698: AND drv.party_id = hpr.party_id
699: AND hpr.status = 'A'
700: AND hpr.subject_table_name = 'HZ_PARTIES'
701: AND hpr.object_table_name = 'HZ_PARTIES'
702: AND hpr.directional_flag = 'F'
703: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
704: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
705: AND hpp.party_id(+) = hpr.subject_id

Line 797: hz_parties hzp

793: -- ams_dm_drv_stg drv,
794: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
795: hz_person_profiles hpp,
796: hz_employment_history heh,
797: hz_parties hzp
798: WHERE
799: drv.party_id = hzp.party_id
800: AND hzp.status = 'A'
801: AND hpp.party_id(+) = hzp.party_id

Line 886: AND hpr.subject_table_name = 'HZ_PARTIES'

882: hz_person_interest hpi,
883: hz_relationships hpr
884: WHERE drv.party_id = hpr.party_id --it's the party of type relationship
885: AND hpr.status = 'A'
886: AND hpr.subject_table_name = 'HZ_PARTIES'
887: AND hpr.object_table_name = 'HZ_PARTIES'
888: AND hpr.directional_flag = 'F'
889: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
890: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 887: AND hpr.object_table_name = 'HZ_PARTIES'

883: hz_relationships hpr
884: WHERE drv.party_id = hpr.party_id --it's the party of type relationship
885: AND hpr.status = 'A'
886: AND hpr.subject_table_name = 'HZ_PARTIES'
887: AND hpr.object_table_name = 'HZ_PARTIES'
888: AND hpr.directional_flag = 'F'
889: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
890: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
891: AND hpi.party_id(+) = hpr.subject_id

Line 1037: AND hpr.subject_table_name = 'HZ_PARTIES'

1033: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1035: WHERE drv.party_id = hpr.party_id
1036: AND hpr.status = 'A'
1037: AND hpr.subject_table_name = 'HZ_PARTIES'
1038: AND hpr.object_table_name = 'HZ_PARTIES'
1039: AND hpr.directional_flag = 'F'
1040: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1041: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1038: AND hpr.object_table_name = 'HZ_PARTIES'

1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr
1035: WHERE drv.party_id = hpr.party_id
1036: AND hpr.status = 'A'
1037: AND hpr.subject_table_name = 'HZ_PARTIES'
1038: AND hpr.object_table_name = 'HZ_PARTIES'
1039: AND hpr.directional_flag = 'F'
1040: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1041: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1042: AND hfr.party_id(+) = hpr.object_id --the org's party id

Line 1133: AND hpr.subject_table_name = 'HZ_PARTIES'

1129: hz_customer_profiles hcp,
1130: hz_relationships hpr
1131: WHERE drv.party_id = hpr.party_id
1132: AND hpr.status = 'A'
1133: AND hpr.subject_table_name = 'HZ_PARTIES'
1134: AND hpr.object_table_name = 'HZ_PARTIES'
1135: AND hpr.directional_flag = 'F'
1136: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1137: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1134: AND hpr.object_table_name = 'HZ_PARTIES'

1130: hz_relationships hpr
1131: WHERE drv.party_id = hpr.party_id
1132: AND hpr.status = 'A'
1133: AND hpr.subject_table_name = 'HZ_PARTIES'
1134: AND hpr.object_table_name = 'HZ_PARTIES'
1135: AND hpr.directional_flag = 'F'
1136: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1137: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1138: AND hca.party_id = hpr.object_id --the org's party id

Line 1253: AND hpr.subject_table_name = 'HZ_PARTIES'

1249: FROM hz_person_profiles hpp,hz_relationships hpr,ams_dm_drv_stg_gt drv
1250: WHERE hpp.party_id = hpr.subject_id
1251: AND drv.party_id = hpr.party_id
1252: AND hpr.status = 'A'
1253: AND hpr.subject_table_name = 'HZ_PARTIES'
1254: AND hpr.object_table_name = 'HZ_PARTIES'
1255: AND hpr.directional_flag = 'F'
1256: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1257: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1254: AND hpr.object_table_name = 'HZ_PARTIES'

1250: WHERE hpp.party_id = hpr.subject_id
1251: AND drv.party_id = hpr.party_id
1252: AND hpr.status = 'A'
1253: AND hpr.subject_table_name = 'HZ_PARTIES'
1254: AND hpr.object_table_name = 'HZ_PARTIES'
1255: AND hpr.directional_flag = 'F'
1256: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1257: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1258: AND (SYSDATE BETWEEN hpp.effective_start_date AND NVL(hpp.effective_end_date,SYSDATE))

Line 1274: AND hpr.subject_table_name = 'HZ_PARTIES'

1270: FROM hz_education hze, ams_dm_drv_stg_gt drv, hz_relationships hpr
1271: WHERE hze.party_id = hpr.subject_id
1272: AND drv.party_id = hpr.party_id
1273: AND hpr.status = 'A'
1274: AND hpr.subject_table_name = 'HZ_PARTIES'
1275: AND hpr.object_table_name = 'HZ_PARTIES'
1276: AND hpr.directional_flag = 'F'
1277: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1278: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1275: AND hpr.object_table_name = 'HZ_PARTIES'

1271: WHERE hze.party_id = hpr.subject_id
1272: AND drv.party_id = hpr.party_id
1273: AND hpr.status = 'A'
1274: AND hpr.subject_table_name = 'HZ_PARTIES'
1275: AND hpr.object_table_name = 'HZ_PARTIES'
1276: AND hpr.directional_flag = 'F'
1277: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1278: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1279: AND hze.status = 'A'

Line 1404: AND hpr.subject_table_name = 'HZ_PARTIES'

1400: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv, hz_relationships hpr
1401: WHERE hca.party_id = hpr.object_id
1402: AND drv.party_id = hpr.party_id
1403: AND hpr.status = 'A'
1404: AND hpr.subject_table_name = 'HZ_PARTIES'
1405: AND hpr.object_table_name = 'HZ_PARTIES'
1406: AND hpr.directional_flag = 'F'
1407: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1408: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1405: AND hpr.object_table_name = 'HZ_PARTIES'

1401: WHERE hca.party_id = hpr.object_id
1402: AND drv.party_id = hpr.party_id
1403: AND hpr.status = 'A'
1404: AND hpr.subject_table_name = 'HZ_PARTIES'
1405: AND hpr.object_table_name = 'HZ_PARTIES'
1406: AND hpr.directional_flag = 'F'
1407: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1408: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1409: AND hca.status = 'A'

Line 1884: AND hpr.subject_table_name = 'HZ_PARTIES'

1880: (select party_id
1881: from hz_relationships hpr
1882: where object_id=drv.party_id
1883: AND hpr.status = 'A'
1884: AND hpr.subject_table_name = 'HZ_PARTIES'
1885: AND hpr.object_table_name = 'HZ_PARTIES'
1886: AND hpr.directional_flag = 'F'
1887: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1888: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1885: AND hpr.object_table_name = 'HZ_PARTIES'

1881: from hz_relationships hpr
1882: where object_id=drv.party_id
1883: AND hpr.status = 'A'
1884: AND hpr.subject_table_name = 'HZ_PARTIES'
1885: AND hpr.object_table_name = 'HZ_PARTIES'
1886: AND hpr.directional_flag = 'F'
1887: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1888: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1889: )

Line 1901: AND hpr.subject_table_name = 'HZ_PARTIES'

1897: (select party_id
1898: from hz_relationships hpr
1899: where object_id=drv.party_id
1900: AND hpr.status = 'A'
1901: AND hpr.subject_table_name = 'HZ_PARTIES'
1902: AND hpr.object_table_name = 'HZ_PARTIES'
1903: AND hpr.directional_flag = 'F'
1904: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1905: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1902: AND hpr.object_table_name = 'HZ_PARTIES'

1898: from hz_relationships hpr
1899: where object_id=drv.party_id
1900: AND hpr.status = 'A'
1901: AND hpr.subject_table_name = 'HZ_PARTIES'
1902: AND hpr.object_table_name = 'HZ_PARTIES'
1903: AND hpr.directional_flag = 'F'
1904: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1905: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1906: )

Line 1927: AND hpr.subject_table_name = 'HZ_PARTIES'

1923: (select party_id
1924: from hz_relationships hpr
1925: where object_id=drv.party_id
1926: AND hpr.status = 'A'
1927: AND hpr.subject_table_name = 'HZ_PARTIES'
1928: AND hpr.object_table_name = 'HZ_PARTIES'
1929: AND hpr.directional_flag = 'F'
1930: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1931: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1928: AND hpr.object_table_name = 'HZ_PARTIES'

1924: from hz_relationships hpr
1925: where object_id=drv.party_id
1926: AND hpr.status = 'A'
1927: AND hpr.subject_table_name = 'HZ_PARTIES'
1928: AND hpr.object_table_name = 'HZ_PARTIES'
1929: AND hpr.directional_flag = 'F'
1930: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1931: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1932: )

Line 1951: AND hpr.subject_table_name = 'HZ_PARTIES'

1947: (select party_id
1948: from hz_relationships hpr
1949: where object_id=drv.party_id
1950: AND hpr.status = 'A'
1951: AND hpr.subject_table_name = 'HZ_PARTIES'
1952: AND hpr.object_table_name = 'HZ_PARTIES'
1953: AND hpr.directional_flag = 'F'
1954: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1955: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1952: AND hpr.object_table_name = 'HZ_PARTIES'

1948: from hz_relationships hpr
1949: where object_id=drv.party_id
1950: AND hpr.status = 'A'
1951: AND hpr.subject_table_name = 'HZ_PARTIES'
1952: AND hpr.object_table_name = 'HZ_PARTIES'
1953: AND hpr.directional_flag = 'F'
1954: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1955: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1956: ))

Line 1969: AND hpr.subject_table_name = 'HZ_PARTIES'

1965: (select party_id
1966: from hz_relationships hpr
1967: where object_id=drv.party_id
1968: AND hpr.status = 'A'
1969: AND hpr.subject_table_name = 'HZ_PARTIES'
1970: AND hpr.object_table_name = 'HZ_PARTIES'
1971: AND hpr.directional_flag = 'F'
1972: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1973: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1970: AND hpr.object_table_name = 'HZ_PARTIES'

1966: from hz_relationships hpr
1967: where object_id=drv.party_id
1968: AND hpr.status = 'A'
1969: AND hpr.subject_table_name = 'HZ_PARTIES'
1970: AND hpr.object_table_name = 'HZ_PARTIES'
1971: AND hpr.directional_flag = 'F'
1972: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1973: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1974: )

Line 1994: AND hpr.subject_table_name = 'HZ_PARTIES'

1990: (select party_id
1991: from hz_relationships hpr
1992: where object_id=drv.party_id
1993: AND hpr.status = 'A'
1994: AND hpr.subject_table_name = 'HZ_PARTIES'
1995: AND hpr.object_table_name = 'HZ_PARTIES'
1996: AND hpr.directional_flag = 'F'
1997: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1998: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 1995: AND hpr.object_table_name = 'HZ_PARTIES'

1991: from hz_relationships hpr
1992: where object_id=drv.party_id
1993: AND hpr.status = 'A'
1994: AND hpr.subject_table_name = 'HZ_PARTIES'
1995: AND hpr.object_table_name = 'HZ_PARTIES'
1996: AND hpr.directional_flag = 'F'
1997: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
1998: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
1999: )

Line 2019: AND hpr.subject_table_name = 'HZ_PARTIES'

2015: (select party_id
2016: from hz_relationships hpr
2017: where object_id=drv.party_id
2018: AND hpr.status = 'A'
2019: AND hpr.subject_table_name = 'HZ_PARTIES'
2020: AND hpr.object_table_name = 'HZ_PARTIES'
2021: AND hpr.directional_flag = 'F'
2022: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2023: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2020: AND hpr.object_table_name = 'HZ_PARTIES'

2016: from hz_relationships hpr
2017: where object_id=drv.party_id
2018: AND hpr.status = 'A'
2019: AND hpr.subject_table_name = 'HZ_PARTIES'
2020: AND hpr.object_table_name = 'HZ_PARTIES'
2021: AND hpr.directional_flag = 'F'
2022: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2023: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2024: )

Line 2038: AND hpr.subject_table_name = 'HZ_PARTIES'

2034: (select party_id
2035: from hz_relationships hpr
2036: where object_id=drv.party_id
2037: AND hpr.status = 'A'
2038: AND hpr.subject_table_name = 'HZ_PARTIES'
2039: AND hpr.object_table_name = 'HZ_PARTIES'
2040: AND hpr.directional_flag = 'F'
2041: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2042: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2039: AND hpr.object_table_name = 'HZ_PARTIES'

2035: from hz_relationships hpr
2036: where object_id=drv.party_id
2037: AND hpr.status = 'A'
2038: AND hpr.subject_table_name = 'HZ_PARTIES'
2039: AND hpr.object_table_name = 'HZ_PARTIES'
2040: AND hpr.directional_flag = 'F'
2041: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2042: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2043: )

Line 2077: AND hpr.subject_table_name = 'HZ_PARTIES'

2073: (select party_id
2074: from hz_relationships hpr
2075: where object_id=drv.party_id
2076: AND hpr.status = 'A'
2077: AND hpr.subject_table_name = 'HZ_PARTIES'
2078: AND hpr.object_table_name = 'HZ_PARTIES'
2079: AND hpr.directional_flag = 'F'
2080: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2081: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2078: AND hpr.object_table_name = 'HZ_PARTIES'

2074: from hz_relationships hpr
2075: where object_id=drv.party_id
2076: AND hpr.status = 'A'
2077: AND hpr.subject_table_name = 'HZ_PARTIES'
2078: AND hpr.object_table_name = 'HZ_PARTIES'
2079: AND hpr.directional_flag = 'F'
2080: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2081: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2082: )

Line 2106: AND hpr.subject_table_name = 'HZ_PARTIES'

2102: (select party_id
2103: from hz_relationships hpr
2104: where object_id=drv.party_id
2105: AND hpr.status = 'A'
2106: AND hpr.subject_table_name = 'HZ_PARTIES'
2107: AND hpr.object_table_name = 'HZ_PARTIES'
2108: AND hpr.directional_flag = 'F'
2109: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2110: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2107: AND hpr.object_table_name = 'HZ_PARTIES'

2103: from hz_relationships hpr
2104: where object_id=drv.party_id
2105: AND hpr.status = 'A'
2106: AND hpr.subject_table_name = 'HZ_PARTIES'
2107: AND hpr.object_table_name = 'HZ_PARTIES'
2108: AND hpr.directional_flag = 'F'
2109: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2110: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2111: )

Line 2715: AND hpr.subject_table_name = 'HZ_PARTIES'

2711: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Table
2712: hz_relationships hpr
2713: WHERE drv.party_id = hpr.party_id
2714: AND hpr.status = 'A'
2715: AND hpr.subject_table_name = 'HZ_PARTIES'
2716: AND hpr.object_table_name = 'HZ_PARTIES'
2717: AND hpr.directional_flag = 'F'
2718: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2719: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))

Line 2716: AND hpr.object_table_name = 'HZ_PARTIES'

2712: hz_relationships hpr
2713: WHERE drv.party_id = hpr.party_id
2714: AND hpr.status = 'A'
2715: AND hpr.subject_table_name = 'HZ_PARTIES'
2716: AND hpr.object_table_name = 'HZ_PARTIES'
2717: AND hpr.directional_flag = 'F'
2718: AND hpr.relationship_code IN ('CONTACT_OF' , 'EMPLOYEE_OF')
2719: AND (SYSDATE BETWEEN hpr.start_date and NVL(hpr.end_date,SYSDATE))
2720: AND bps.party_id(+) = hpr.object_id --the org's party id