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_CONTACTS

Line 169: from hz_shadow_st_contacts;

165: (party_id, person_party_id, qkey, org_contact_id, parent_rowid, concat_col,status_flag) -- Fix for bug 5155761
166: select decode(party_id,person_party_id,NULL,party_id),person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Fix for bug 5155761
167: --(party_id, qkey, org_contact_id, parent_rowid, concat_col,status_flag)-- Bug No: 4299785
168: --select party_id, qkey,org_contact_id,ROWID,null,status_flag -- Bug No: 4299785
169: from hz_shadow_st_contacts;
170: log('End Time for Contacts ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
171: ELSIF p_entity = 'CONTACT_POINTS'
172: THEN
173: log('Start Time for Contact Points ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

Line 209: log('Truncating HZ_SHADOW_ST_CONTACTS .. ', FALSE);

205: log('Truncating HZ_SHADOW_ST_PSITES .. ', FALSE);
206: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PSITES';
207: log('Done');
208:
209: log('Truncating HZ_SHADOW_ST_CONTACTS .. ', FALSE);
210: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_CONTACTS';
211: log('Done');
212:
213: log('Truncating HZ_SHADOW_ST_CPTS .. ', FALSE);

Line 210: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_CONTACTS';

206: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PSITES';
207: log('Done');
208:
209: log('Truncating HZ_SHADOW_ST_CONTACTS .. ', FALSE);
210: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_CONTACTS';
211: log('Done');
212:
213: log('Truncating HZ_SHADOW_ST_CPTS .. ', FALSE);
214: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.hz_shadow_st_cpts';

Line 350: l(' from hz_shadow_st_contacts p,hz_thin_st_contacts t ');

346: l_trns1 := 'P.PERSON_PARTY_ID';
347: l('||');
348: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
349: l(' data ');
350: l(' from hz_shadow_st_contacts p,hz_thin_st_contacts t ');
351: end if;
352: if p_entity = 'CONTACT_POINTS' then
353: l_trns := 'PARTY_ID';
354: l_trns1 := 'P.PARTY_ID';

Line 702: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',

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;
706: log('Done with dropping btree indexes on Base Staging tables');

Line 2183: l(' UPDATE HZ_SHADOW_ST_CONTACTS SET ');

2179: l(' UPDATE HZ_SHADOW_ST_PSITES SET ');
2180: l(' ' || l_update_str);
2181: l(' WHERE party_site_id = p_record_id;');
2182: ELSIF p_entity = 'CONTACTS' THEN
2183: l(' UPDATE HZ_SHADOW_ST_CONTACTS SET ');
2184: l(' ' || l_update_str);
2185: l(' WHERE org_contact_id = p_record_id;');
2186: ELSIF p_entity = 'CONTACT_POINTS' THEN
2187: l(' UPDATE HZ_SHADOW_ST_CPTS SET ');

Line 3747: l(' INSERT INTO HZ_SHADOW_ST_CONTACTS (');

3743: l(' l_en := H_C_PARTY_ID.COUNT; ');
3744: l(' LOOP ');
3745: l(' BEGIN ');
3746: l(' FORALL I in l_st..l_en');
3747: l(' INSERT INTO HZ_SHADOW_ST_CONTACTS (');
3748: l(' ORG_CONTACT_ID');
3749: l(' ,PARTY_ID');
3750: l(' ,PERSON_PARTY_ID');
3751: l(' ,STATUS_FLAG');-- Bug No: 4299785

Line 3872: l(' INSERT INTO HZ_SHADOW_ST_CONTACTS (');

3868: l(' WHILE (l_tryins OR l_tryupd) LOOP');
3869: l(' IF l_tryins THEN');
3870: l(' BEGIN');
3871: l(' l_tryins:=FALSE;');
3872: l(' INSERT INTO HZ_SHADOW_ST_CONTACTS (');
3873: l(' ORG_CONTACT_ID');
3874: l(' ,PARTY_ID');
3875: l(' ,STATUS_FLAG '); -- Bug No: 4299785
3876: FOR I IN 1..255 LOOP

Line 3901: l(' UPDATE HZ_SHADOW_ST_CONTACTS SET ');

3897: l(' END IF;');
3898: l(' IF l_tryupd THEN');
3899: l(' BEGIN');
3900: l(' l_tryupd:=FALSE;');
3901: l(' UPDATE HZ_SHADOW_ST_CONTACTS SET ');
3902: FOR I IN 1..255 LOOP
3903: IF l_forall_list(I) <> 'N' THEN
3904: IF (is_first) THEN
3905: is_first := false;

Line 4354: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',

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',
4358: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS') table_name,

Line 4357: 'PARTY_SITES','HZ_SHADOW_ST_PSITES','CONTACTS','HZ_SHADOW_ST_CONTACTS',

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',
4361: 'CONTACT_POINTS','HZ_SRCH_CPTS')||'_N0'||substrb(staged_attribute_column,3) srch_index_name,