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_CPTS

Line 179: from hz_shadow_st_cpts;

175: (party_id, partition_id, contact_point_id, party_site_id,
176: person_party_id, parent_rowid, org_contact_id, qkey, concat_col,status_flag) -- Bug No: 4299785
177: select decode(party_id,person_party_id,NULL,party_id), decode(contact_point_type,'PHONE',0,'EMAIL',1,2),contact_point_id,party_site_id, person_party_id,ROWID,org_contact_id, qkey, null,status_flag -- Fix for bug 5155761
178: --select party_id, decode(contact_point_type,'PHONE',0,'EMAIL',1,2),contact_point_id,party_site_id,person_party_id,ROWID,org_contact_id, qkey, null,status_flag -- Bug No: 4299785
179: from hz_shadow_st_cpts;
180: log('End Time for Contact Points ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
181: END IF ;
182: END ;
183:

Line 213: log('Truncating HZ_SHADOW_ST_CPTS .. ', FALSE);

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';
215: log('Done');
216:
217: /* Not Needed for staging SHADOW

Line 214: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.hz_shadow_st_cpts';

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';
215: log('Done');
216:
217: /* Not Needed for staging SHADOW
218: log('Attempting to truncate HZ_DQM_SYNC_INTERFACE ..',FALSE);

Line 366: l(' from HZ_SHADOW_ST_CPTS p,hz_thin_st_cpts t '); -- Bug 5209633

362: l_trns1 := 'P.CONTACT_POINT_TYPE';
363: l('||');
364: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
365: l(' data ');
366: l(' from HZ_SHADOW_ST_CPTS p,hz_thin_st_cpts t '); -- Bug 5209633
367: end if;
368: l(' where t.ROWID = rid and p.ROWID=parent_rowid) LOOP ');
369: l(' data := R.data;');
370: l(' dbms_lob.writeappend(tlob, length(data),data);');

Line 703: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS')||'_N0'||f.function_id) LOOP

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');
707: /* Not Needed for R12 SHADOW STAGING

Line 2187: l(' UPDATE HZ_SHADOW_ST_CPTS SET ');

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 ');
2188: l(' ' || l_update_str);
2189: l(' WHERE contact_point_id = p_record_id;');
2190: END IF;
2191: END IF;

Line 4163: l(' INSERT INTO HZ_SHADOW_ST_CPTS (');

4159: l(' l_en := H_CPT_PARTY_ID.COUNT; ');
4160: l(' LOOP ');
4161: l(' BEGIN ');
4162: l(' FORALL I in l_st..l_en');
4163: l(' INSERT INTO HZ_SHADOW_ST_CPTS (');
4164: l(' CONTACT_POINT_ID');
4165: l(' ,PARTY_ID');
4166: l(' ,PARTY_SITE_ID');
4167: l(' ,ORG_CONTACT_ID');

Line 4279: l(' INSERT INTO HZ_SHADOW_ST_CPTS (');

4275: l(' WHILE (l_tryins OR l_tryupd) LOOP');
4276: l(' IF l_tryins THEN');
4277: l(' BEGIN');
4278: l(' l_tryins:=FALSE;');
4279: l(' INSERT INTO HZ_SHADOW_ST_CPTS (');
4280: l(' CONTACT_POINT_ID');
4281: l(' ,PARTY_ID');
4282: l(' ,PARTY_SITE_ID');
4283: l(' ,ORG_CONTACT_ID');

Line 4316: l(' UPDATE HZ_SHADOW_ST_CPTS SET ');

4312: l(' END IF;');
4313: l(' IF l_tryupd THEN');
4314: l(' BEGIN');
4315: l(' l_tryupd:=FALSE;');
4316: l(' UPDATE HZ_SHADOW_ST_CPTS SET ');
4317: FOR I IN 1..255 LOOP
4318: IF l_forall_list(I) <> 'N' THEN
4319: IF (is_first) THEN
4320: is_first := false;

Line 4355: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS')||'_N0'||substrb(staged_attribute_column,3) index_name,

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,
4359: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',

Line 4358: 'CONTACT_POINTS','HZ_SHADOW_ST_CPTS') table_name,

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,
4362: decode(a.entity_name,'PARTY','HZ_SRCH_PARTIES',