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_WRAPPER dependencies on HZ_IMP_PARTIES_SG

Line 653: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';

649:
650: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
651:
652: IF P_BATCH_MODE_FLAG = 'Y' THEN
653: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
654: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
655: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
656: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CREDITRTNGS_SG TRUNCATE PARTITION batchpar DROP STORAGE';
657: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CLASSIFICS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 666: DELETE HZ_IMP_PARTIES_SG

662: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTROLES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
663: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSUSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
664:
665: ELSE
666: DELETE HZ_IMP_PARTIES_SG
667: WHERE batch_id = P_BATCH_ID
668: AND batch_mode_flag = P_BATCH_MODE_FLAG;
669: DELETE HZ_IMP_ADDRESSES_SG
670: WHERE batch_id = P_BATCH_ID

Line 982: TYPE L_ROWIDList IS TABLE OF HZ_IMP_PARTIES_SG.INT_ROW_ID%TYPE;

978: P_ENTITY IN VARCHAR2,
979: P_PARTY_OS IN VARCHAR2)
980: IS
981:
982: TYPE L_ROWIDList IS TABLE OF HZ_IMP_PARTIES_SG.INT_ROW_ID%TYPE;
983: TYPE L_PIDList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ID%TYPE;
984: TYPE L_POSList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM%TYPE;
985: TYPE L_POSRList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
986: l_rowid L_ROWIDList;

Line 983: TYPE L_PIDList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ID%TYPE;

979: P_PARTY_OS IN VARCHAR2)
980: IS
981:
982: TYPE L_ROWIDList IS TABLE OF HZ_IMP_PARTIES_SG.INT_ROW_ID%TYPE;
983: TYPE L_PIDList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ID%TYPE;
984: TYPE L_POSList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM%TYPE;
985: TYPE L_POSRList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
986: l_rowid L_ROWIDList;
987: l_pid L_PIDList;

Line 984: TYPE L_POSList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM%TYPE;

980: IS
981:
982: TYPE L_ROWIDList IS TABLE OF HZ_IMP_PARTIES_SG.INT_ROW_ID%TYPE;
983: TYPE L_PIDList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ID%TYPE;
984: TYPE L_POSList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM%TYPE;
985: TYPE L_POSRList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
986: l_rowid L_ROWIDList;
987: l_pid L_PIDList;
988: l_pos L_POSList;

Line 985: TYPE L_POSRList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;

981:
982: TYPE L_ROWIDList IS TABLE OF HZ_IMP_PARTIES_SG.INT_ROW_ID%TYPE;
983: TYPE L_PIDList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ID%TYPE;
984: TYPE L_POSList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM%TYPE;
985: TYPE L_POSRList IS TABLE OF HZ_IMP_PARTIES_SG.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
986: l_rowid L_ROWIDList;
987: l_pid L_PIDList;
988: l_pos L_POSList;
989: l_posr L_POSRList;

Line 1004: from hz_imp_parties_sg

1000: SELECT ROW_ID,party_id,party_os, party_osr
1001: FROM
1002: ( SELECT int_row_id row_id,party_id,PARTY_ORIG_SYSTEM party_os,PARTY_ORIG_SYSTEM_REFERENCE party_osr
1003: ,row_number() over (partition by party_id order by int_row_id) rn
1004: from hz_imp_parties_sg
1005: where batch_id=P_BATCH_ID
1006: and batch_mode_flag=P_BATCH_MODE_FLAG
1007: and party_orig_system = P_PARTY_OS
1008: and action_flag='U'

Line 1026: FROM hz_imp_parties_int pint, hz_imp_parties_sg psg

1022: WHERE rn>1;
1023:
1024: CURSOR c_parties_d IS
1025: SELECT pint.party_orig_system, pint.party_orig_system_reference,psg.party_id
1026: FROM hz_imp_parties_int pint, hz_imp_parties_sg psg
1027: WHERE pint.batch_id=P_BATCH_ID
1028: AND pint.party_orig_system=P_PARTY_OS
1029: AND pint.interface_status='D'
1030: AND Pint.rowid=psg.int_row_id

Line 1213: hz_imp_parties_sg ps

1209: select /*+ parallel(pi) leading (pi) use_nl(ps) use_nl(osr) */
1210: ps.party_id, osr.owner_table_id displayed_duns_party_id
1211: from hz_orig_sys_references osr,
1212: hz_imp_parties_int pi,
1213: hz_imp_parties_sg ps
1214: where osr.owner_table_name = 'HZ_PARTIES'
1215: and osr.orig_system = 'DNB'
1216: and osr.orig_system_reference = pi.displayed_duns
1217: and pi.batch_id = p_batch_id

Line 3655: FROM hz_imp_parties_sg

3651: WHERE batch_id = p_batch_id;
3652:
3653: CURSOR c_sg_data(p_batch_id number) IS
3654: SELECT 'Y'
3655: FROM hz_imp_parties_sg
3656: WHERE batch_id = p_batch_id
3657: AND rownum = 1;
3658:
3659: CURSOR c_wu(p_batch_id number) IS

Line 4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);

4033: IF P_BATCH_MODE_FLAG = 'Y' THEN
4034: -- Analyze parties staging after matching
4035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze party staging table ' ||
4036: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);
4038: END IF;
4039:
4040: elsif (stage=3) then
4041: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 2 ');

Line 4670: FROM HZ_IMP_PARTIES_SG

4666: SELECT 'Y'
4667: FROM dual
4668: WHERE EXISTS (
4669: SELECT 'Y'
4670: FROM HZ_IMP_PARTIES_SG
4671: WHERE batch_id = p_batch_id
4672: AND batch_mode_flag = p_batch_mode_flag
4673: AND rownum = 1)
4674: OR EXISTS (