APPS.HZ_DQM_DIAGNOSTICS_XML dependencies on HZ_STAGED_PARTY_SITES

Line 106: l_st_psites_size := GET_TABLE_SIZE('HZ_STAGED_PARTY_SITES');

102: l_xml_header := '';
103: l_xml_header := l_xml_header ||l_new_line||'';
104: l_xml_header := l_xml_header ||l_new_line||''||l_time||'';
105: l_st_parties_size := GET_TABLE_SIZE('HZ_STAGED_PARTIES');
106: l_st_psites_size := GET_TABLE_SIZE('HZ_STAGED_PARTY_SITES');
107: l_st_pcnts_size := GET_TABLE_SIZE('HZ_STAGED_CONTACTS');
108: l_st_pcnpts_size := GET_TABLE_SIZE('HZ_STAGED_CONTACT_POINTS');
109: l_total_size := l_st_parties_size+l_st_psites_size+l_st_pcnts_size+l_st_pcnpts_size;
110: l_xml_header := l_xml_header ||l_new_line||''||l_total_size||'';

Line 141: select count(party_site_id) into l_staged_cnt from hz_staged_party_sites where org_contact_id IS NULL and party_id in

137:
138: select count(party_site_id) into l_entity_cnt from hz_party_sites where party_id in
139: (select party_id from hz_parties where party_type in ('ORGANIZATION','PERSON'));
140: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_entity_cnt)||'';
141: select count(party_site_id) into l_staged_cnt from hz_staged_party_sites where org_contact_id IS NULL and party_id in
142: (select party_id from hz_staged_parties where TX36 in ('ORGANIZATION ','PERSON ')) ;
143: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_staged_cnt)||'';
144: select count(distinct(party_id)) into l_sync_cnt from hz_dqm_sync_interface where entity='PARTY_SITES'
145: and party_id in (select party_id from hz_parties where party_type in ('ORGANIZATION','PERSON'));

Line 296: ' and ind.table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') '||

292: ' union select ''HZ_STAGE_PARTY_SITES_T1'' index_name, count(*) index_errors from ctxsys.ctx_index_errors where err_index_name like ''HZ_STAGE_PARTY_SITES_T1'' '||
293: ' union select ''HZ_STAGE_CONTACT_T1'' index_name, count(*) index_errors from ctxsys.ctx_index_errors where err_index_name like ''HZ_STAGE_CONTACT_T1'' '||
294: ' union select ''HZ_STAGE_CPT_T1'' index_name, count(*) index_errors from ctxsys.ctx_index_errors where err_index_name like ''HZ_STAGE_CPT_T1'' '||
295: ' ) b where ind.index_name like ''HZ_STAGE%T1'' '||
296: ' and ind.table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') '||
297: ' and st.operation=''CREATE_INDEXES'' and st.step in (''HZ_PARTIES'',''HZ_PARTY_SITES'',''HZ_ORG_CONTACTS'',''HZ_CONTACT_POINTS'') '||
298: ' and (decode(ind.table_name,''HZ_STAGED_PARTIES'',''HZ_PARTIES'') = st.step '||
299: ' OR decode(ind.table_name,''HZ_STAGED_PARTY_SITES'',''HZ_PARTY_SITES'') = st.step '||
300: ' OR decode(ind.table_name,''HZ_STAGED_CONTACTS'',''HZ_ORG_CONTACTS'') = st.step '||

Line 299: ' OR decode(ind.table_name,''HZ_STAGED_PARTY_SITES'',''HZ_PARTY_SITES'') = st.step '||

295: ' ) b where ind.index_name like ''HZ_STAGE%T1'' '||
296: ' and ind.table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') '||
297: ' and st.operation=''CREATE_INDEXES'' and st.step in (''HZ_PARTIES'',''HZ_PARTY_SITES'',''HZ_ORG_CONTACTS'',''HZ_CONTACT_POINTS'') '||
298: ' and (decode(ind.table_name,''HZ_STAGED_PARTIES'',''HZ_PARTIES'') = st.step '||
299: ' OR decode(ind.table_name,''HZ_STAGED_PARTY_SITES'',''HZ_PARTY_SITES'') = st.step '||
300: ' OR decode(ind.table_name,''HZ_STAGED_CONTACTS'',''HZ_ORG_CONTACTS'') = st.step '||
301: ' OR decode(ind.table_name,''HZ_STAGED_CONTACT_POINTS'',''HZ_CONTACT_POINTS'') = st.step) '||
302: ' and a.index_name = b.index_name '||
303: ' and a.index_name = ind.index_name '); */

Line 324: ' OR decode(I.table_name, ''HZ_STAGED_PARTY_SITES'', ''HZ_PARTY_SITES'' ) = st.step '||

320: ' AND I.INDEX_NAME = E.err_index_name(+) '||
321: ' AND I.OWNER = E.err_index_owner(+) '||
322: ' AND st.operation=''CREATE_INDEXES'' '||
323: ' AND (decode(I.table_name, ''HZ_STAGED_PARTIES'', ''HZ_PARTIES'') = st.step '||
324: ' OR decode(I.table_name, ''HZ_STAGED_PARTY_SITES'', ''HZ_PARTY_SITES'' ) = st.step '||
325: ' OR decode(I.table_name, ''HZ_STAGED_CONTACTS'', ''HZ_ORG_CONTACTS'') = st.step '||
326: ' OR decode(I.table_name, ''HZ_STAGED_CONTACT_POINTS'', ''HZ_CONTACT_POINTS'') = st.step) ');
327:
328: DBMS_XMLGEN.setRowTag(qryCtx, 'Intermedia index details');

Line 363: qryCtx := dbms_xmlgen.newContext('select * from sys.dba_ind_columns where table_owner=''AR'' and table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') ');

359: l_result_length,l_resultOffset);
360: END IF;
361:
362: if(fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner)) then
363: qryCtx := dbms_xmlgen.newContext('select * from sys.dba_ind_columns where table_owner=''AR'' and table_name in(''HZ_STAGED_PARTIES'',''HZ_STAGED_PARTY_SITES'',''HZ_STAGED_CONTACTS'',''HZ_STAGED_CONTACT_POINTS'') ');
364: DBMS_XMLGEN.setRowTag(qryCtx, 'Bulk Indexes');
365: l_result := DBMS_XMLGEN.getXML(qryCtx);
366: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
367: IF l_rows_processed <> 0 THEN