APPS.HZ_DQM_DIAGNOSTICS_XML dependencies on HZ_CONTACT_POINTS

Line 169: select count(contact_point_id) into l_entity_cnt from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES');

165: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_sync_cnt)||'';
166: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_st_pcnts_size)||'';
167: l_xml_header := l_xml_header ||l_new_line||''||GET_TABLE_SIZE('HZ_ORG_CONTACTS')||'';
168:
169: select count(contact_point_id) into l_entity_cnt from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES');
170: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_entity_cnt)||'';
171:
172: select count(contact_point_id) into l_staged_cnt from hz_staged_contact_points where contact_point_id in
173: (select contact_point_id from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES'));

Line 173: (select contact_point_id from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES'));

169: select count(contact_point_id) into l_entity_cnt from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES');
170: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_entity_cnt)||'';
171:
172: select count(contact_point_id) into l_staged_cnt from hz_staged_contact_points where contact_point_id in
173: (select contact_point_id from hz_contact_points where owner_table_name in ('HZ_PARTIES','HZ_PARTY_SITES'));
174: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_staged_cnt)||'';
175: select count(distinct(party_id)) into l_sync_cnt from hz_dqm_sync_interface where entity='CONTACT_POINTS'
176: and party_id in (select party_id from hz_parties where party_type in ('ORGANIZATION','PERSON'));
177: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_sync_cnt)||'';

Line 179: l_xml_header := l_xml_header || l_new_line||''||to_char(GET_TABLE_SIZE('HZ_CONTACT_POINTS'))||'';

175: select count(distinct(party_id)) into l_sync_cnt from hz_dqm_sync_interface where entity='CONTACT_POINTS'
176: and party_id in (select party_id from hz_parties where party_type in ('ORGANIZATION','PERSON'));
177: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_sync_cnt)||'';
178: l_xml_header := l_xml_header ||l_new_line||''||to_char(l_st_pcnpts_size)||'';
179: l_xml_header := l_xml_header || l_new_line||''||to_char(GET_TABLE_SIZE('HZ_CONTACT_POINTS'))||'';
180: l_xml_header := l_xml_header ||l_new_line||''||l_index_time||'';
181:
182: select count(*) into l_schedule_cnt from fnd_concurrent_requests where concurrent_program_id=44464
183: and phase_code='P';

Line 297: ' and st.operation=''CREATE_INDEXES'' and st.step in (''HZ_PARTIES'',''HZ_PARTY_SITES'',''HZ_ORG_CONTACTS'',''HZ_CONTACT_POINTS'') '||

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 '||
301: ' OR decode(ind.table_name,''HZ_STAGED_CONTACT_POINTS'',''HZ_CONTACT_POINTS'') = st.step) '||

Line 301: ' OR decode(ind.table_name,''HZ_STAGED_CONTACT_POINTS'',''HZ_CONTACT_POINTS'') = st.step) '||

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 '); */
304:
305: qryCtx := dbms_xmlgen.newContext(' SELECT I.INDEX_NAME, I.table_name, I.status, I.index_type, substr(I.parameters, instr(I.parameters, ''memory'')+6) memory, '||

Line 326: ' OR decode(I.table_name, ''HZ_STAGED_CONTACT_POINTS'', ''HZ_CONTACT_POINTS'') = st.step) ');

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');
329: l_result := DBMS_XMLGEN.getXML(qryCtx);
330: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);