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.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_PARTIES_SG

Line 53: into hz_imp_parties_sg

49: --dbms_output.put_line('flag 1');
50: insert all
51: when ( 1 = 1 )
52: then
53: into hz_imp_parties_sg
54: (
55: PARTY_ID,
56: PARTY_ORIG_SYSTEM,
57: PARTY_ORIG_SYSTEM_REFERENCE,

Line 134: into hz_imp_parties_sg

130:
131: insert all
132: when ( 1 = 1 )
133: then
134: into hz_imp_parties_sg
135: (
136: PARTY_ID,
137: PARTY_ORIG_SYSTEM,
138: PARTY_ORIG_SYSTEM_REFERENCE,

Line 211: insert into hz_imp_parties_sg

207: -- re-run for legacy system, OSR change ignored
208:
209: --dbms_output.put_line('flag 3');
210:
211: insert into hz_imp_parties_sg
212: (
213: PARTY_ID,
214: PARTY_ORIG_SYSTEM,
215: PARTY_ORIG_SYSTEM_REFERENCE,

Line 245: insert into hz_imp_parties_sg

241: -- first run for legacy system, OSR change ignored
242:
243: --dbms_output.put_line('flag 4');
244:
245: insert into hz_imp_parties_sg
246: (
247: PARTY_ID,
248: PARTY_ORIG_SYSTEM,
249: PARTY_ORIG_SYSTEM_REFERENCE,

Line 391: hz_imp_parties_sg psg,

387: osr_change_tbl.new_osr_exists_flag psg_new_osr_flag,
388: ps_int.primary_flag primary_flag,
389: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
390: from hz_imp_addresses_int ps_int,
391: hz_imp_parties_sg psg,
392: hz_orig_sys_references mosr,
393: hz_imp_osr_change osr_change_tbl
394: where mosr.owner_table_name (+) = 'HZ_PARTIES'
395: and mosr.status (+) = 'A'

Line 520: hz_imp_parties_sg psg,

516: osr_change_tbl.new_osr_exists_flag psg_new_osr_flag,
517: ps_int.primary_flag primary_flag,
518: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
519: from hz_imp_addresses_int ps_int,
520: hz_imp_parties_sg psg,
521: hz_orig_sys_references mosr,
522: hz_imp_osr_change osr_change_tbl
523: where mosr.owner_table_name (+) = 'HZ_PARTIES'
524: and mosr.status (+) = 'A'

Line 632: hz_imp_parties_sg psg,

628: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
629: cp_int.batch_id, cp_int.contact_point_type,
630: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
631: from hz_imp_contactpts_int cp_int,
632: hz_imp_parties_sg psg,
633: hz_orig_sys_references mosr,
634: hz_imp_osr_change party_osr_ch_tbl
635: where cp_int.interface_status = 'C'
636: and cp_int.batch_id = P_BATCH_ID

Line 743: hz_imp_parties_sg psg,

739: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
740: cp_int.batch_id, cp_int.contact_point_type,
741: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
742: from hz_imp_contactpts_int cp_int,
743: hz_imp_parties_sg psg,
744: hz_orig_sys_references mosr,
745: hz_imp_osr_change party_osr_ch_tbl
746: where cp_int.interface_status is null
747: and cp_int.batch_id = P_BATCH_ID

Line 839: hz_imp_parties_sg party_sg,

835: cr_int.party_orig_system_reference party_osr,
836: cr_int.rated_as_of_date, cr_int.rating_organization
837: rating_org, cr_int.rowid int_row_id
838: from hz_imp_creditrtngs_int cr_int,
839: hz_imp_parties_sg party_sg,
840: hz_orig_sys_references mosr,
841: hz_imp_osr_change osr_ch_tbl
842: where cr_int.interface_status = 'C'
843: and cr_int.batch_id = P_BATCH_ID

Line 897: hz_imp_parties_sg party_sg,

893: cr_int.party_orig_system_reference party_osr,
894: cr_int.rated_as_of_date, cr_int.rating_organization
895: rating_org, cr_int.rowid int_row_id
896: from hz_imp_creditrtngs_int cr_int,
897: hz_imp_parties_sg party_sg,
898: hz_orig_sys_references mosr,
899: hz_imp_osr_change osr_ch_tbl
900: where cr_int.interface_status is null
901: and cr_int.batch_id = P_BATCH_ID

Line 990: hz_imp_parties_sg party_sg,

986: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
987: then 'SIC' else ca_int.class_category end class_category,
988: ca_int.primary_flag
989: from hz_imp_classifics_int ca_int,
990: hz_imp_parties_sg party_sg,
991: hz_orig_sys_references mosr,
992: hz_imp_osr_change osr_ch_tbl
993: where ca_int.interface_status = 'C'
994: and ca_int.batch_id = p_batch_id

Line 1085: hz_imp_parties_sg party_sg,

1081: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1082: then 'SIC' else ca_int.class_category end class_category,
1083: ca_int.primary_flag
1084: from hz_imp_classifics_int ca_int,
1085: hz_imp_parties_sg party_sg,
1086: hz_orig_sys_references mosr,
1087: hz_imp_osr_change osr_ch_tbl
1088: where ca_int.interface_status = 'C'
1089: and ca_int.batch_id = p_batch_id

Line 1179: hz_imp_parties_sg party_sg,

1175: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1176: then 'SIC' else ca_int.class_category end class_category,
1177: ca_int.primary_flag
1178: from hz_imp_classifics_int ca_int,
1179: hz_imp_parties_sg party_sg,
1180: hz_orig_sys_references mosr,
1181: hz_imp_osr_change osr_ch_tbl
1182: where ca_int.interface_status is null
1183: and ca_int.batch_id = p_batch_id

Line 1274: hz_imp_parties_sg party_sg,

1270: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1271: then 'SIC' else ca_int.class_category end class_category,
1272: ca_int.primary_flag
1273: from hz_imp_classifics_int ca_int,
1274: hz_imp_parties_sg party_sg,
1275: hz_orig_sys_references mosr,
1276: hz_imp_osr_change osr_ch_tbl
1277: where ca_int.interface_status is null
1278: and ca_int.batch_id = p_batch_id

Line 1399: hz_imp_parties_sg party_sg,

1395: REPORT_END_DATE,
1396: REPORT_START_DATE,
1397: fr_int.rowid int_row_id
1398: from hz_imp_finreports_int fr_int,
1399: hz_imp_parties_sg party_sg,
1400: hz_orig_sys_references mosr,
1401: hz_imp_osr_change osr_ch_tbl
1402: where fr_int.interface_status = 'C'
1403: and fr_int.batch_id = P_BATCH_ID

Line 1494: hz_imp_parties_sg party_sg,

1490: REPORT_END_DATE,
1491: REPORT_START_DATE,
1492: fr_int.rowid int_row_id
1493: from hz_imp_finreports_int fr_int,
1494: hz_imp_parties_sg party_sg,
1495: hz_orig_sys_references mosr,
1496: hz_imp_osr_change osr_ch_tbl
1497: where fr_int.interface_status is null
1498: and fr_int.batch_id = P_BATCH_ID

Line 1631: hz_imp_parties_sg party_sg,

1627: report_start_date, fn_int.financial_number_name,
1628: fn_int.rowid int_row_id,
1629: fn_int.batch_id
1630: from hz_imp_finnumbers_int fn_int,
1631: hz_imp_parties_sg party_sg,
1632: hz_orig_sys_references mosr,
1633: hz_imp_osr_change osr_ch_tbl
1634: where fn_int.interface_status = 'C'
1635: and fn_int.batch_id = P_BATCH_ID

Line 1766: hz_imp_parties_sg party_sg,

1762: report_start_date, fn_int.financial_number_name,
1763: fn_int.rowid int_row_id,
1764: fn_int.batch_id
1765: from hz_imp_finnumbers_int fn_int,
1766: hz_imp_parties_sg party_sg,
1767: hz_orig_sys_references mosr,
1768: hz_imp_osr_change osr_ch_tbl
1769: where fn_int.interface_status is null
1770: and fn_int.batch_id = P_BATCH_ID

Line 1885: HZ_IMP_PARTIES_SG PARTY_SGA,

1881: obj_int.party_type obj_type
1882: from hz_imp_RELSHIPS_int ri,
1883: hz_orig_sys_references mosr,
1884: hz_orig_sys_references mosr2,
1885: HZ_IMP_PARTIES_SG PARTY_SGA,
1886: HZ_IMP_PARTIES_SG PARTY_SGB,
1887: hz_imp_osr_change sub_osr_ch_tbl,
1888: hz_imp_osr_change obj_osr_ch_tbl,
1889: hz_imp_parties_int sub_int,

Line 1886: HZ_IMP_PARTIES_SG PARTY_SGB,

1882: from hz_imp_RELSHIPS_int ri,
1883: hz_orig_sys_references mosr,
1884: hz_orig_sys_references mosr2,
1885: HZ_IMP_PARTIES_SG PARTY_SGA,
1886: HZ_IMP_PARTIES_SG PARTY_SGB,
1887: hz_imp_osr_change sub_osr_ch_tbl,
1888: hz_imp_osr_change obj_osr_ch_tbl,
1889: hz_imp_parties_int sub_int,
1890: hz_imp_parties_int obj_int

Line 1991: HZ_IMP_PARTIES_SG PARTY_SGA,

1987: obj_int.party_type obj_type
1988: from hz_imp_RELSHIPS_int ri,
1989: hz_orig_sys_references mosr,
1990: hz_orig_sys_references mosr2,
1991: HZ_IMP_PARTIES_SG PARTY_SGA,
1992: HZ_IMP_PARTIES_SG PARTY_SGB,
1993: hz_imp_osr_change sub_osr_ch_tbl,
1994: hz_imp_osr_change obj_osr_ch_tbl,
1995: hz_imp_parties_int sub_int,

Line 1992: HZ_IMP_PARTIES_SG PARTY_SGB,

1988: from hz_imp_RELSHIPS_int ri,
1989: hz_orig_sys_references mosr,
1990: hz_orig_sys_references mosr2,
1991: HZ_IMP_PARTIES_SG PARTY_SGA,
1992: HZ_IMP_PARTIES_SG PARTY_SGB,
1993: hz_imp_osr_change sub_osr_ch_tbl,
1994: hz_imp_osr_change obj_osr_ch_tbl,
1995: hz_imp_parties_int sub_int,
1996: hz_imp_parties_int obj_int

Line 2097: HZ_IMP_PARTIES_SG PARTY_SGA,

2093: obj_int.party_type obj_type
2094: from hz_imp_RELSHIPS_int ri,
2095: hz_orig_sys_references mosr,
2096: hz_orig_sys_references mosr2,
2097: HZ_IMP_PARTIES_SG PARTY_SGA,
2098: HZ_IMP_PARTIES_SG PARTY_SGB,
2099: hz_imp_osr_change sub_osr_ch_tbl,
2100: hz_imp_osr_change obj_osr_ch_tbl,
2101: hz_imp_parties_int sub_int,

Line 2098: HZ_IMP_PARTIES_SG PARTY_SGB,

2094: from hz_imp_RELSHIPS_int ri,
2095: hz_orig_sys_references mosr,
2096: hz_orig_sys_references mosr2,
2097: HZ_IMP_PARTIES_SG PARTY_SGA,
2098: HZ_IMP_PARTIES_SG PARTY_SGB,
2099: hz_imp_osr_change sub_osr_ch_tbl,
2100: hz_imp_osr_change obj_osr_ch_tbl,
2101: hz_imp_parties_int sub_int,
2102: hz_imp_parties_int obj_int

Line 2203: HZ_IMP_PARTIES_SG PARTY_SGA,

2199: obj_int.party_type obj_type
2200: from hz_imp_RELSHIPS_int ri,
2201: hz_orig_sys_references mosr,
2202: hz_orig_sys_references mosr2,
2203: HZ_IMP_PARTIES_SG PARTY_SGA,
2204: HZ_IMP_PARTIES_SG PARTY_SGB,
2205: hz_imp_osr_change sub_osr_ch_tbl,
2206: hz_imp_osr_change obj_osr_ch_tbl,
2207: hz_imp_parties_int sub_int,

Line 2204: HZ_IMP_PARTIES_SG PARTY_SGB,

2200: from hz_imp_RELSHIPS_int ri,
2201: hz_orig_sys_references mosr,
2202: hz_orig_sys_references mosr2,
2203: HZ_IMP_PARTIES_SG PARTY_SGA,
2204: HZ_IMP_PARTIES_SG PARTY_SGB,
2205: hz_imp_osr_change sub_osr_ch_tbl,
2206: hz_imp_osr_change obj_osr_ch_tbl,
2207: hz_imp_parties_int sub_int,
2208: hz_imp_parties_int obj_int

Line 2316: hz_imp_parties_sg sub_sg,

2312: nvl(obj_sg.action_flag,'U') PARTY_ACTION_FLAG,
2313: P_BATCH_MODE_FLAG, P_BATCH_ID
2314: from hz_imp_contacts_int cont_int,
2315: hz_orig_sys_references cont_mosr,
2316: hz_imp_parties_sg sub_sg,
2317: hz_orig_sys_references sub_mosr,
2318: hz_imp_parties_sg obj_sg,
2319: hz_imp_parties_int sub_int,
2320: hz_imp_parties_int obj_int, /*6913856 */

Line 2318: hz_imp_parties_sg obj_sg,

2314: from hz_imp_contacts_int cont_int,
2315: hz_orig_sys_references cont_mosr,
2316: hz_imp_parties_sg sub_sg,
2317: hz_orig_sys_references sub_mosr,
2318: hz_imp_parties_sg obj_sg,
2319: hz_imp_parties_int sub_int,
2320: hz_imp_parties_int obj_int, /*6913856 */
2321: hz_orig_sys_references obj_mosr
2322: where cont_int.batch_id = P_BATCH_ID

Line 2398: hz_imp_parties_sg sub_sg,

2394: nvl(obj_sg.action_flag,'U') PARTY_ACTION_FLAG,
2395: P_BATCH_MODE_FLAG, P_BATCH_ID
2396: from hz_imp_contacts_int cont_int,
2397: hz_orig_sys_references cont_mosr,
2398: hz_imp_parties_sg sub_sg,
2399: hz_orig_sys_references sub_mosr,
2400: hz_imp_parties_sg obj_sg,
2401: hz_imp_parties_int sub_int,
2402: hz_imp_parties_int obj_int,

Line 2400: hz_imp_parties_sg obj_sg,

2396: from hz_imp_contacts_int cont_int,
2397: hz_orig_sys_references cont_mosr,
2398: hz_imp_parties_sg sub_sg,
2399: hz_orig_sys_references sub_mosr,
2400: hz_imp_parties_sg obj_sg,
2401: hz_imp_parties_int sub_int,
2402: hz_imp_parties_int obj_int,
2403: hz_orig_sys_references obj_mosr
2404: where cont_int.batch_id = P_BATCH_ID

Line 2496: hz_imp_parties_sg party_sg,

2492: conrole_int.role_type role_type
2493: from hz_imp_contactroles_int conrole_int,
2494: hz_imp_contacts_sg cont_sg,
2495: hz_orig_sys_references con_mosr,
2496: hz_imp_parties_sg party_sg,
2497: hz_orig_sys_references party_mosr--,
2498: where conrole_int.batch_id = P_BATCH_ID
2499: and conrole_int.sub_orig_system = P_OS
2500: and conrole_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2565: hz_imp_parties_sg party_sg,

2561: conrole_int.role_type role_type
2562: from hz_imp_contactroles_int conrole_int,
2563: hz_imp_contacts_sg cont_sg,
2564: hz_orig_sys_references con_mosr,
2565: hz_imp_parties_sg party_sg,
2566: hz_orig_sys_references party_mosr--,
2567: where conrole_int.batch_id = P_BATCH_ID
2568: and conrole_int.sub_orig_system = P_OS
2569: and conrole_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2660: hz_imp_parties_sg party_sg,

2656: addr_sg.party_id addr_party_id, addruse_int.site_use_type,
2657: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2658: addruse_int.primary_flag
2659: from hz_imp_addressuses_int addruse_int,
2660: hz_imp_parties_sg party_sg,
2661: hz_imp_addresses_sg addr_sg,
2662: hz_orig_sys_references addr_mosr,
2663: hz_orig_sys_references party_mosr
2664: where addruse_int.batch_id = P_BATCH_ID

Line 2741: hz_imp_parties_sg party_sg,

2737: addr_sg.party_id addr_party_id, addruse_int.site_use_type,
2738: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2739: addruse_int.primary_flag
2740: from hz_imp_addressuses_int addruse_int,
2741: hz_imp_parties_sg party_sg,
2742: hz_imp_addresses_sg addr_sg,
2743: hz_orig_sys_references addr_mosr,
2744: hz_orig_sys_references party_mosr
2745: where addruse_int.batch_id = P_BATCH_ID