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_PARTY_STAGE_SHADOW dependencies on HZ_SHADOW_ST_PARTIES

Line 149: from hz_shadow_st_parties;

145: log('Start Time for Parties ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
146: insert /*+ append */ into hz_thin_st_parties
147: (party_id, status, partition_id, parent_rowid, concat_col)
148: select party_id, status, decode(TX36, 'ORGANIZATION ',0,'PERSON ',1,1),ROWID,null
149: from hz_shadow_st_parties;
150: log('End Time for Parties ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
151: ELSIF p_entity = 'PARTY_SITES'
152: THEN
153: log('Start Time for Party Sites ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

Line 201: log('Truncating HZ_SHADOW_ST_PARTIES .. ', FALSE);

197: where object_name = 'HZ_STAGED_PARTIES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1;*/
198: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_STAGED_PARTIES'' and owner = :1';
199: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;
200: END IF;
201: log('Truncating HZ_SHADOW_ST_PARTIES .. ', FALSE);
202: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PARTIES';
203: log('Done');
204:
205: log('Truncating HZ_SHADOW_ST_PSITES .. ', FALSE);

Line 202: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PARTIES';

198: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_STAGED_PARTIES'' and owner = :1';
199: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;
200: END IF;
201: log('Truncating HZ_SHADOW_ST_PARTIES .. ', FALSE);
202: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PARTIES';
203: log('Done');
204:
205: log('Truncating HZ_SHADOW_ST_PSITES .. ', FALSE);
206: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PSITES';

Line 324: l(' ,p.STATUS from hz_shadow_st_parties p,hz_thin_st_parties t '); -- Bug 5209633

320:
321: -- Begin Code changes for bug 5155761
322: if p_entity = 'PARTY' then
323: l(' data ');
324: l(' ,p.STATUS from hz_shadow_st_parties p,hz_thin_st_parties t '); -- Bug 5209633
325: end if;
326:
327: --Create party_id, person_party and contact_point_type section
328: if p_entity = 'PARTY_SITES' then

Line 701: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',

697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
698: WHERE f.attribute_id = a.attribute_id
699: AND i.owner = l_owner1
700: AND f.index_required_flag in ('Y','T')
701: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',
702: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',
703: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS')||'_N0'||f.function_id) LOOP
704: EXECUTE IMMEDIATE 'DROP INDEX '||IDX.idx_name;
705: END LOOP;

Line 2175: l(' UPDATE HZ_SHADOW_ST_PARTIES SET ');

2171: END LOOP;
2172:
2173: IF l_update_str IS NOT NULL THEN
2174: IF p_entity = 'PARTY' THEN
2175: l(' UPDATE HZ_SHADOW_ST_PARTIES SET ');
2176: l(' ' || l_update_str);
2177: l(' WHERE party_id = p_record_id;');
2178: ELSIF p_entity = 'PARTY_SITES' THEN
2179: l(' UPDATE HZ_SHADOW_ST_PSITES SET ');

Line 2743: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');

2739: END LOOP;
2740:
2741: l(' FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op ');
2742: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2743: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2744: l(' WHERE sp.party_id = p.party_id) ' );
2745: l(' AND p.party_id = op.party_id ');
2746: l(' AND op.effective_end_date is NULL ');
2747: l(' AND p.PARTY_TYPE =''ORGANIZATION'' ');

Line 2759: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');

2755: END IF;
2756: END LOOP;
2757: l(' FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe ');
2758: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2759: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2760: l(' WHERE sp.party_id = p.party_id) ' );
2761: l(' AND p.party_id = pe.party_id ');
2762: l(' AND pe.effective_end_date is NULL ');
2763: l(' AND p.PARTY_TYPE =''PERSON'' ');

Line 2775: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');

2771: END IF;
2772: END LOOP;
2773: l(' FROM HZ_PARTIES p ');
2774: l(' WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number ');
2775: l(' AND NOT EXISTS (select 1 FROM HZ_SHADOW_ST_PARTIES sp ');
2776: l(' WHERE sp.party_id = p.party_id) ' );
2777: l(' AND p.party_type <> ''PERSON'' ');
2778: l(' AND p.party_type <> ''ORGANIZATION'' ');
2779: l(' AND p.party_type <> ''PARTY_RELATIONSHIP'' ');

Line 2889: l(' INSERT INTO HZ_SHADOW_ST_PARTIES (');

2885: l(' l_en := H_P_PARTY_ID.COUNT; ');
2886: l(' LOOP ');
2887: l(' BEGIN ');
2888: l(' FORALL I in l_st..l_en');
2889: l(' INSERT INTO HZ_SHADOW_ST_PARTIES (');
2890: l(' PARTY_ID');
2891: l(' ,STATUS');
2892: FOR I IN 1..255 LOOP
2893: IF l_forall_list(I) <> 'N' THEN

Line 3045: l(' INSERT INTO HZ_SHADOW_ST_PARTIES (');

3041: l(' WHILE (l_tryins OR l_tryupd) LOOP');
3042: l(' IF l_tryins THEN');
3043: l(' BEGIN');
3044: l(' l_tryins:=FALSE;');
3045: l(' INSERT INTO HZ_SHADOW_ST_PARTIES (');
3046: l(' PARTY_ID');
3047: l(' ,STATUS');
3048: l(' ,D_PS');
3049: l(' ,D_CT');

Line 3078: l(' UPDATE HZ_SHADOW_ST_PARTIES SET ');

3074: l(' END IF;');
3075: l(' IF l_tryupd THEN');
3076: l(' BEGIN');
3077: l(' l_tryupd:=FALSE;');
3078: l(' UPDATE HZ_SHADOW_ST_PARTIES SET ');
3079: l(' status =H_STATUS(1) ');
3080: FOR I IN 1..255 LOOP
3081: IF l_forall_list(I) <> 'N' THEN
3082: l(' ,TX'||I||'=decode(H_TX'||I||'(1),null,H_TX'||I||'(1),H_TX'||I||'(1)||'' '')');

Line 3508: l(' UPDATE HZ_SHADOW_ST_PARTIES set');

3504: l(' END IF;');
3505: l(' END;');
3506: l(' END IF;');
3507: l(' END LOOP;');
3508: l(' UPDATE HZ_SHADOW_ST_PARTIES set');
3509: l(' D_PS = ''SYNC''');
3510: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
3511: l(' END;');
3512: END;

Line 3925: l(' UPDATE HZ_SHADOW_ST_PARTIES set');

3921: l(' END IF;');
3922: l(' END;');
3923: l(' END IF;');
3924: l(' END LOOP;');
3925: l(' UPDATE HZ_SHADOW_ST_PARTIES set');
3926: l(' D_CT = ''SYNC''');
3927: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
3928: l(' END;');
3929: END;

Line 4340: l(' UPDATE HZ_SHADOW_ST_PARTIES set');

4336: l(' END IF;');
4337: l(' END;');
4338: l(' END IF;');
4339: l(' END LOOP;');
4340: l(' UPDATE HZ_SHADOW_ST_PARTIES set');
4341: l(' D_CPT = ''SYNC''');
4342: l(' WHERE PARTY_ID = H_PARTY_ID(1);');
4343: l(' END;');
4344: END;

Line 4353: SELECT decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',

4349: IS
4350: l_index_owner VARCHAR2(255);
4351:
4352: CURSOR indexes_reqd IS
4353: SELECT decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',
4354: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',
4355: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS')||'_N0'||substrb(staged_attribute_column,3) index_name,
4356: decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',
4357: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',

Line 4356: decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',

4352: CURSOR indexes_reqd IS
4353: SELECT decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',
4354: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',
4355: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS')||'_N0'||substrb(staged_attribute_column,3) index_name,
4356: decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',
4357: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',
4358: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS') table_name,
4359: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',
4360: 'PARTY_SITES','HZ_SRCH_PSITES','CONTACTS','HZ_SRCH_CONTACTS',