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_RELATIONSHIPS

Line 286: FROM hz_relationships c

282: AND b.party_id = x.party_id
283: AND SYSDATE BETWEEN b.effective_start_date AND NVL(b.effective_end_date,SYSDATE))
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'

Line 693: hz_relationships hpr,

689: hz_person_profiles hpp,
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'

Line 883: hz_relationships hpr

879: 'SMOKE',0, 1)) interest_other_flag
880: -- FROM ams_dm_drv_stg drv,
881: FROM ams_dm_drv_stg_gt drv, -- nyostos - Sept 15, 2003 - Global Temp Table
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'

Line 1033: -- FROM ams_dm_drv_stg drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr

1029: -- NULL capital_type_indicator ,
1030: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
1031: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
1032: -- nyostos - Sep 15, 2003 - Global Temp Table
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'

Line 1034: FROM ams_dm_drv_stg_gt drv, hz_financial_numbers hzf, hz_financial_reports hfr, hz_relationships hpr

1030: SUM(DECODE (hzf.financial_number_name,'ACCOUNTS_RECEIVABLE',hzf.financial_number,0)) accounts_receivable ,
1031: SUM(DECODE (hzf.financial_number_name,'RETAINED_EARNINGS',hzf.financial_number,0)) retained_earnings
1032: -- nyostos - Sep 15, 2003 - Global Temp Table
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'

Line 1130: hz_relationships hpr

1126: -- ams_dm_drv_stg drv,
1127: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Tables
1128: hz_cust_accounts hca,
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'

Line 1249: FROM hz_person_profiles hpp,hz_relationships hpr,ams_dm_drv_stg_gt drv

1245: GROUP BY drv.party_id,hpp.date_of_birth;
1246:
1247: CURSOR c_age_b2b IS
1248: SELECT SYSDATE - hpp.date_of_birth,drv.party_id
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'

Line 1270: FROM hz_education hze, ams_dm_drv_stg_gt drv, hz_relationships hpr

1266: GROUP BY drv.party_id;
1267:
1268: CURSOR c_days_since_last_school_b2b IS
1269: SELECT SYSDATE - MAX(hze.last_date_attended), drv.party_id
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'

Line 1400: FROM hz_cust_accounts hca, ams_dm_drv_stg_gt drv, hz_relationships hpr

1396: 0,--SYSDATE - MAX(hca.account_termination_date),
1397: 0 --SYSDATE - MAX(hca.account_activation_date)
1398: , drv.party_id
1399: -- SYSDATE - MAX(hca.account_suspension_date)
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'

Line 1881: from hz_relationships hpr

1877: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1878: FROM ams_event_registrations aer
1879: WHERE aer.attendant_party_id in
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'

Line 1898: from hz_relationships hpr

1894: SELECT COUNT(DISTINCT ale.list_header_id),drv.party_id
1895: FROM ams_list_entries ale, ams_dm_drv_stg_gt drv,ams_list_headers_all hdr
1896: WHERE ale.party_id in
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'

Line 1924: from hz_relationships hpr

1920: (SELECT ale.list_header_id
1921: FROM ams_list_entries ale
1922: WHERE ale.party_id in
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'

Line 1948: from hz_relationships hpr

1944: AND alh.list_header_id IN (SELECT ale.list_header_id
1945: FROM ams_list_entries ale
1946: WHERE ale.party_id in
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'

Line 1966: from hz_relationships hpr

1962: WHERE aeo.event_offer_id IN (SELECT aer.event_offer_id
1963: FROM ams_event_registrations aer
1964: WHERE aer.attendant_party_id in
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'

Line 1991: from hz_relationships hpr

1987: AND aal.list_header_id IN (SELECT ale.list_header_id
1988: FROM ams_list_entries ale
1989: WHERE ale.party_id in
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'

Line 2016: from hz_relationships hpr

2012: AND aal.list_used_by = 'CSCH'
2013: AND aal.list_act_type = 'TARGET'
2014: AND ale.party_id in
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'

Line 2035: from hz_relationships hpr

2031: WHERE aeo.event_offer_id IN (SELECT 1
2032: FROM ams_event_registrations aer
2033: WHERE aer.attendant_party_id in
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'

Line 2074: from hz_relationships hpr

2070: --AND acs.activity_id = ame.media_id
2071: AND aal.list_header_id = ale.list_header_id
2072: AND ale.party_id in
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'

Line 2103: from hz_relationships hpr

2099: AND acs.activity_id = aao.activity_offer_id
2100: AND aal.list_header_id = ale.list_header_id
2101: AND ale. party_id in
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'

Line 2712: hz_relationships hpr

2708: AVG(bps.profitability) profitability
2709: FROM bic_party_summ bps,
2710: -- ams_dm_drv_stg drv,
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'