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_PSITES

Line 159: from hz_shadow_st_psites;

155: (party_id, party_site_id, person_party_id, qkey, org_contact_id,
156: parent_rowid, concat_col,status_flag) -- Bug No: 4299785
157: select decode(party_id,person_party_id,NULL,party_id), party_site_id,person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Fix for bug 5155761
158: --select party_id, party_site_id,person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Bug No: 4299785
159: from hz_shadow_st_psites;
160: log('End Time for Party Sites ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
161: ELSIF p_entity = 'CONTACTS'
162: THEN
163: log('Start Time for Contacts ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

Line 205: log('Truncating HZ_SHADOW_ST_PSITES .. ', FALSE);

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';
207: log('Done');
208:
209: log('Truncating HZ_SHADOW_ST_CONTACTS .. ', FALSE);

Line 206: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_PSITES';

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';
207: log('Done');
208:
209: log('Truncating HZ_SHADOW_ST_CONTACTS .. ', FALSE);
210: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_SHADOW_ST_CONTACTS';

Line 338: l(' from hz_shadow_st_psites p,hz_thin_st_psites t ');

334: l_trns1 := 'P.PERSON_PARTY_ID';
335: l('||');
336: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
337: l(' data ');
338: l(' from hz_shadow_st_psites p,hz_thin_st_psites t ');
339: end if;
340: if p_entity = 'CONTACTS' then
341: l_trns := 'PARTY_ID';
342: 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 2179: l(' UPDATE HZ_SHADOW_ST_PSITES SET ');

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 ');
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 ');

Line 3329: l(' INSERT INTO HZ_SHADOW_ST_PSITES (');

3325: l(' l_en := H_PS_PARTY_ID.COUNT; ');
3326: l(' LOOP ');
3327: l(' BEGIN ');
3328: l(' FORALL I in l_st..l_en');
3329: l(' INSERT INTO HZ_SHADOW_ST_PSITES (');
3330: l(' PARTY_SITE_ID');
3331: l(' ,PARTY_ID');
3332: l(' ,ORG_CONTACT_ID');
3333: l(' ,PERSON_PARTY_ID');

Line 3452: l(' INSERT INTO HZ_SHADOW_ST_PSITES (');

3448: l(' WHILE (l_tryins OR l_tryupd) LOOP');
3449: l(' IF l_tryins THEN');
3450: l(' BEGIN');
3451: l(' l_tryins:=FALSE;');
3452: l(' INSERT INTO HZ_SHADOW_ST_PSITES (');
3453: l(' PARTY_SITE_ID');
3454: l(' ,PARTY_ID');
3455: l(' ,ORG_CONTACT_ID');
3456: l(' ,STATUS_FLAG');-- Bug No: 4299785

Line 3483: l(' UPDATE HZ_SHADOW_ST_PSITES SET ');

3479: l(' END IF;');
3480: l(' IF l_tryupd THEN');
3481: l(' BEGIN');
3482: l(' l_tryupd:=FALSE;');
3483: l(' UPDATE HZ_SHADOW_ST_PSITES SET ');
3484:
3485: FOR I IN 1..255 LOOP
3486: IF l_forall_list(I) <> 'N' THEN
3487: IF (is_first) THEN

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,