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 521: hz_imp_parties_sg psg,

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

Line 634: hz_imp_parties_sg psg,

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

Line 747: hz_imp_parties_sg psg,

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

Line 845: hz_imp_parties_sg party_sg,

841: cr_int.party_orig_system_reference party_osr,
842: cr_int.rated_as_of_date, cr_int.rating_organization
843: rating_org, cr_int.rowid int_row_id
844: from hz_imp_creditrtngs_int cr_int,
845: hz_imp_parties_sg party_sg,
846: hz_orig_sys_references mosr,
847: hz_imp_osr_change osr_ch_tbl
848: where cr_int.interface_status = 'C'
849: and cr_int.batch_id = P_BATCH_ID

Line 904: hz_imp_parties_sg party_sg,

900: cr_int.party_orig_system_reference party_osr,
901: cr_int.rated_as_of_date, cr_int.rating_organization
902: rating_org, cr_int.rowid int_row_id
903: from hz_imp_creditrtngs_int cr_int,
904: hz_imp_parties_sg party_sg,
905: hz_orig_sys_references mosr,
906: hz_imp_osr_change osr_ch_tbl
907: where cr_int.interface_status is null
908: and cr_int.batch_id = P_BATCH_ID

Line 998: hz_imp_parties_sg party_sg,

994: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
995: then 'SIC' else ca_int.class_category end class_category,
996: ca_int.primary_flag
997: from hz_imp_classifics_int ca_int,
998: hz_imp_parties_sg party_sg,
999: hz_orig_sys_references mosr,
1000: hz_imp_osr_change osr_ch_tbl
1001: where ca_int.interface_status = 'C'
1002: and ca_int.batch_id = p_batch_id

Line 1094: hz_imp_parties_sg party_sg,

1090: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1091: then 'SIC' else ca_int.class_category end class_category,
1092: ca_int.primary_flag
1093: from hz_imp_classifics_int ca_int,
1094: hz_imp_parties_sg party_sg,
1095: hz_orig_sys_references mosr,
1096: hz_imp_osr_change osr_ch_tbl
1097: where ca_int.interface_status = 'C'
1098: and ca_int.batch_id = p_batch_id

Line 1189: hz_imp_parties_sg party_sg,

1185: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1186: then 'SIC' else ca_int.class_category end class_category,
1187: ca_int.primary_flag
1188: from hz_imp_classifics_int ca_int,
1189: hz_imp_parties_sg party_sg,
1190: hz_orig_sys_references mosr,
1191: hz_imp_osr_change osr_ch_tbl
1192: where ca_int.interface_status is null
1193: and ca_int.batch_id = p_batch_id

Line 1285: hz_imp_parties_sg party_sg,

1281: in ('1972 SIC', '1977 SIC', '1987 SIC', 'NAICS_1997')
1282: then 'SIC' else ca_int.class_category end class_category,
1283: ca_int.primary_flag
1284: from hz_imp_classifics_int ca_int,
1285: hz_imp_parties_sg party_sg,
1286: hz_orig_sys_references mosr,
1287: hz_imp_osr_change osr_ch_tbl
1288: where ca_int.interface_status is null
1289: and ca_int.batch_id = p_batch_id

Line 1411: hz_imp_parties_sg party_sg,

1407: REPORT_END_DATE,
1408: REPORT_START_DATE,
1409: fr_int.rowid int_row_id
1410: from hz_imp_finreports_int fr_int,
1411: hz_imp_parties_sg party_sg,
1412: hz_orig_sys_references mosr,
1413: hz_imp_osr_change osr_ch_tbl
1414: where fr_int.interface_status = 'C'
1415: and fr_int.batch_id = P_BATCH_ID

Line 1507: hz_imp_parties_sg party_sg,

1503: REPORT_END_DATE,
1504: REPORT_START_DATE,
1505: fr_int.rowid int_row_id
1506: from hz_imp_finreports_int fr_int,
1507: hz_imp_parties_sg party_sg,
1508: hz_orig_sys_references mosr,
1509: hz_imp_osr_change osr_ch_tbl
1510: where fr_int.interface_status is null
1511: and fr_int.batch_id = P_BATCH_ID

Line 1645: hz_imp_parties_sg party_sg,

1641: report_start_date, fn_int.financial_number_name,
1642: fn_int.rowid int_row_id,
1643: fn_int.batch_id
1644: from hz_imp_finnumbers_int fn_int,
1645: hz_imp_parties_sg party_sg,
1646: hz_orig_sys_references mosr,
1647: hz_imp_osr_change osr_ch_tbl
1648: where fn_int.interface_status = 'C'
1649: and fn_int.batch_id = P_BATCH_ID

Line 1781: hz_imp_parties_sg party_sg,

1777: report_start_date, fn_int.financial_number_name,
1778: fn_int.rowid int_row_id,
1779: fn_int.batch_id
1780: from hz_imp_finnumbers_int fn_int,
1781: hz_imp_parties_sg party_sg,
1782: hz_orig_sys_references mosr,
1783: hz_imp_osr_change osr_ch_tbl
1784: where fn_int.interface_status is null
1785: and fn_int.batch_id = P_BATCH_ID

Line 1902: HZ_IMP_PARTIES_SG PARTY_SGA,

1898: obj_int.party_type obj_type
1899: from hz_imp_RELSHIPS_int ri,
1900: hz_orig_sys_references mosr,
1901: hz_orig_sys_references mosr2,
1902: HZ_IMP_PARTIES_SG PARTY_SGA,
1903: HZ_IMP_PARTIES_SG PARTY_SGB,
1904: hz_imp_osr_change sub_osr_ch_tbl,
1905: hz_imp_osr_change obj_osr_ch_tbl,
1906: hz_imp_parties_int sub_int,

Line 1903: HZ_IMP_PARTIES_SG PARTY_SGB,

1899: from hz_imp_RELSHIPS_int ri,
1900: hz_orig_sys_references mosr,
1901: hz_orig_sys_references mosr2,
1902: HZ_IMP_PARTIES_SG PARTY_SGA,
1903: HZ_IMP_PARTIES_SG PARTY_SGB,
1904: hz_imp_osr_change sub_osr_ch_tbl,
1905: hz_imp_osr_change obj_osr_ch_tbl,
1906: hz_imp_parties_int sub_int,
1907: hz_imp_parties_int obj_int

Line 2012: HZ_IMP_PARTIES_SG PARTY_SGA,

2008: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2009: from hz_imp_RELSHIPS_int ri,
2010: hz_orig_sys_references mosr,
2011: hz_orig_sys_references mosr2,
2012: HZ_IMP_PARTIES_SG PARTY_SGA,
2013: HZ_IMP_PARTIES_SG PARTY_SGB,
2014: hz_imp_osr_change sub_osr_ch_tbl,
2015: hz_imp_osr_change obj_osr_ch_tbl,
2016: hz_imp_parties_int sub_int,

Line 2013: HZ_IMP_PARTIES_SG PARTY_SGB,

2009: from hz_imp_RELSHIPS_int ri,
2010: hz_orig_sys_references mosr,
2011: hz_orig_sys_references mosr2,
2012: HZ_IMP_PARTIES_SG PARTY_SGA,
2013: HZ_IMP_PARTIES_SG PARTY_SGB,
2014: hz_imp_osr_change sub_osr_ch_tbl,
2015: hz_imp_osr_change obj_osr_ch_tbl,
2016: hz_imp_parties_int sub_int,
2017: hz_imp_parties_int obj_int

Line 2122: HZ_IMP_PARTIES_SG PARTY_SGA,

2118: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2119: from hz_imp_RELSHIPS_int ri,
2120: hz_orig_sys_references mosr,
2121: hz_orig_sys_references mosr2,
2122: HZ_IMP_PARTIES_SG PARTY_SGA,
2123: HZ_IMP_PARTIES_SG PARTY_SGB,
2124: hz_imp_osr_change sub_osr_ch_tbl,
2125: hz_imp_osr_change obj_osr_ch_tbl,
2126: hz_imp_parties_int sub_int,

Line 2123: HZ_IMP_PARTIES_SG PARTY_SGB,

2119: from hz_imp_RELSHIPS_int ri,
2120: hz_orig_sys_references mosr,
2121: hz_orig_sys_references mosr2,
2122: HZ_IMP_PARTIES_SG PARTY_SGA,
2123: HZ_IMP_PARTIES_SG PARTY_SGB,
2124: hz_imp_osr_change sub_osr_ch_tbl,
2125: hz_imp_osr_change obj_osr_ch_tbl,
2126: hz_imp_parties_int sub_int,
2127: hz_imp_parties_int obj_int

Line 2231: HZ_IMP_PARTIES_SG PARTY_SGA,

2227: NULLIF(sub_osr_ch_tbl.entity_id, PARTY_SGB.party_id) subject_osr_change /* Bug 5383200 */
2228: from hz_imp_RELSHIPS_int ri,
2229: hz_orig_sys_references mosr,
2230: hz_orig_sys_references mosr2,
2231: HZ_IMP_PARTIES_SG PARTY_SGA,
2232: HZ_IMP_PARTIES_SG PARTY_SGB,
2233: hz_imp_osr_change sub_osr_ch_tbl,
2234: hz_imp_osr_change obj_osr_ch_tbl,
2235: hz_imp_parties_int sub_int,

Line 2232: HZ_IMP_PARTIES_SG PARTY_SGB,

2228: from hz_imp_RELSHIPS_int ri,
2229: hz_orig_sys_references mosr,
2230: hz_orig_sys_references mosr2,
2231: HZ_IMP_PARTIES_SG PARTY_SGA,
2232: HZ_IMP_PARTIES_SG PARTY_SGB,
2233: hz_imp_osr_change sub_osr_ch_tbl,
2234: hz_imp_osr_change obj_osr_ch_tbl,
2235: hz_imp_parties_int sub_int,
2236: hz_imp_parties_int obj_int

Line 2346: hz_imp_parties_sg sub_sg,

2342: nvl(obj_sg.action_flag,'U') PARTY_ACTION_FLAG,
2343: P_BATCH_MODE_FLAG, P_BATCH_ID
2344: from hz_imp_contacts_int cont_int,
2345: hz_orig_sys_references cont_mosr,
2346: hz_imp_parties_sg sub_sg,
2347: hz_orig_sys_references sub_mosr,
2348: hz_imp_parties_sg obj_sg,
2349: hz_imp_parties_int sub_int,
2350: hz_imp_parties_int obj_int, /*6913856 */

Line 2348: hz_imp_parties_sg obj_sg,

2344: from hz_imp_contacts_int cont_int,
2345: hz_orig_sys_references cont_mosr,
2346: hz_imp_parties_sg sub_sg,
2347: hz_orig_sys_references sub_mosr,
2348: hz_imp_parties_sg obj_sg,
2349: hz_imp_parties_int sub_int,
2350: hz_imp_parties_int obj_int, /*6913856 */
2351: hz_orig_sys_references obj_mosr
2352: where cont_int.batch_id = P_BATCH_ID

Line 2428: hz_imp_parties_sg sub_sg,

2424: nvl(obj_sg.action_flag,'U') PARTY_ACTION_FLAG,
2425: P_BATCH_MODE_FLAG, P_BATCH_ID
2426: from hz_imp_contacts_int cont_int,
2427: hz_orig_sys_references cont_mosr,
2428: hz_imp_parties_sg sub_sg,
2429: hz_orig_sys_references sub_mosr,
2430: hz_imp_parties_sg obj_sg,
2431: hz_imp_parties_int sub_int,
2432: hz_imp_parties_int obj_int,

Line 2430: hz_imp_parties_sg obj_sg,

2426: from hz_imp_contacts_int cont_int,
2427: hz_orig_sys_references cont_mosr,
2428: hz_imp_parties_sg sub_sg,
2429: hz_orig_sys_references sub_mosr,
2430: hz_imp_parties_sg obj_sg,
2431: hz_imp_parties_int sub_int,
2432: hz_imp_parties_int obj_int,
2433: hz_orig_sys_references obj_mosr
2434: where cont_int.batch_id = P_BATCH_ID

Line 2526: hz_imp_parties_sg party_sg,

2522: conrole_int.role_type role_type
2523: from hz_imp_contactroles_int conrole_int,
2524: hz_imp_contacts_sg cont_sg,
2525: hz_orig_sys_references con_mosr,
2526: hz_imp_parties_sg party_sg,
2527: hz_orig_sys_references party_mosr--,
2528: where conrole_int.batch_id = P_BATCH_ID
2529: and conrole_int.sub_orig_system = P_OS
2530: and conrole_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2595: hz_imp_parties_sg party_sg,

2591: conrole_int.role_type role_type
2592: from hz_imp_contactroles_int conrole_int,
2593: hz_imp_contacts_sg cont_sg,
2594: hz_orig_sys_references con_mosr,
2595: hz_imp_parties_sg party_sg,
2596: hz_orig_sys_references party_mosr--,
2597: where conrole_int.batch_id = P_BATCH_ID
2598: and conrole_int.sub_orig_system = P_OS
2599: and conrole_int.sub_orig_system_reference between P_FROM_OSR and P_TO_OSR

Line 2690: hz_imp_parties_sg party_sg,

2686: addr_sg.party_id addr_party_id, addruse_int.site_use_type,
2687: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2688: addruse_int.primary_flag
2689: from hz_imp_addressuses_int addruse_int,
2690: hz_imp_parties_sg party_sg,
2691: hz_imp_addresses_sg addr_sg,
2692: hz_orig_sys_references addr_mosr,
2693: hz_orig_sys_references party_mosr
2694: where addruse_int.batch_id = P_BATCH_ID

Line 2771: hz_imp_parties_sg party_sg,

2767: addr_sg.party_id addr_party_id, addruse_int.site_use_type,
2768: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2769: addruse_int.primary_flag
2770: from hz_imp_addressuses_int addruse_int,
2771: hz_imp_parties_sg party_sg,
2772: hz_imp_addresses_sg addr_sg,
2773: hz_orig_sys_references addr_mosr,
2774: hz_orig_sys_references party_mosr
2775: where addruse_int.batch_id = P_BATCH_ID