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.PV_CATEGORY_MIGRATION dependencies on PV_SINGLE_PROD_H_MAPPINGS2

Line 171: 'INSERT INTO pv_single_prod_h_mappings2

167: WHERE a.attr_value = b.code AND
168: a.attribute_id IN (1, 510)';
169:
170: l_insert_into_table2 VARCHAR2(32000) :=
171: 'INSERT INTO pv_single_prod_h_mappings2
172: SELECT a.attr_value_id,
173: b.product_category_id new_value,
174: a.attribute_value old_value
175: FROM pv_selected_attr_values a,

Line 249: FOR x IN (SELECT 'x' row_exists FROM pv_single_prod_h_mappings2) LOOP

245: FOR x IN (SELECT 'x' row_exists FROM pv_single_prod_h_mappings) LOOP
246: l_revert_entity_attr := TRUE;
247: END LOOP;
248:
249: FOR x IN (SELECT 'x' row_exists FROM pv_single_prod_h_mappings2) LOOP
250: l_revert_selected_attr := TRUE;
251: END LOOP;
252:
253: -- -----------------------------------------------------------------------

Line 287: FROM pv_single_prod_h_mappings2 b

283: l_update_ddl :=
284: 'UPDATE pv_selected_attr_values a
285: SET attribute_value =
286: (SELECT old_value
287: FROM pv_single_prod_h_mappings2 b
288: WHERE a.attr_value_id = b.attr_value_id)
289: WHERE EXISTS (SELECT 1
290: FROM pv_single_prod_h_mappings2 c
291: WHERE a.attr_value_id = c.attr_value_id)';

Line 290: FROM pv_single_prod_h_mappings2 c

286: (SELECT old_value
287: FROM pv_single_prod_h_mappings2 b
288: WHERE a.attr_value_id = b.attr_value_id)
289: WHERE EXISTS (SELECT 1
290: FROM pv_single_prod_h_mappings2 c
291: WHERE a.attr_value_id = c.attr_value_id)';
292:
293: l_string := SUBSTR(l_update_ddl, 1, 300);
294:

Line 459: p_token1_value => 'pv_single_prod_h_mappings2',

455: Debug('(5).');
456: Set_Message(
457: p_msg_name => 'PV_SPH_POPULATE_MAPPING',
458: p_token1 => 'TABLE1',
459: p_token1_value => 'pv_single_prod_h_mappings2',
460: p_token2 => 'TABLE2',
461: p_token2_value => 'pv_selected_attr_values'
462: );
463:

Line 467: l_string := 'DROP INDEX ' || l_pv_schema || '.pv_single_prod_h_mappings2_u1';

463:
464: Debug('-');
465:
466: BEGIN
467: l_string := 'DROP INDEX ' || l_pv_schema || '.pv_single_prod_h_mappings2_u1';
468: EXECUTE IMMEDIATE l_string;
469:
470: EXCEPTION
471: WHEN OTHERS THEN

Line 476: l_string := 'TRUNCATE TABLE ' || l_pv_schema || '.pv_single_prod_h_mappings2';

472: null;
473: END;
474:
475:
476: l_string := 'TRUNCATE TABLE ' || l_pv_schema || '.pv_single_prod_h_mappings2';
477: EXECUTE IMMEDIATE l_string;
478:
479:
480: l_string := SUBSTR(l_insert_into_table2, 1, 300);

Line 492: '.pv_single_prod_h_mappings2_u1 ' ||

488: );
489:
490:
491: l_string := 'CREATE UNIQUE INDEX ' || l_pv_schema ||
492: '.pv_single_prod_h_mappings2_u1 ' ||
493: 'ON pv_single_prod_h_mappings2 (attr_value_id) ' ||
494: 'TABLESPACE ' || l_index_tablespace;
495: EXECUTE IMMEDIATE l_string;
496:

Line 493: 'ON pv_single_prod_h_mappings2 (attr_value_id) ' ||

489:
490:
491: l_string := 'CREATE UNIQUE INDEX ' || l_pv_schema ||
492: '.pv_single_prod_h_mappings2_u1 ' ||
493: 'ON pv_single_prod_h_mappings2 (attr_value_id) ' ||
494: 'TABLESPACE ' || l_index_tablespace;
495: EXECUTE IMMEDIATE l_string;
496:
497: l_string := 'ANALYZE TABLE ' || l_pv_schema ||

Line 498: '.pv_single_prod_h_mappings2 COMPUTE STATISTICS';

494: 'TABLESPACE ' || l_index_tablespace;
495: EXECUTE IMMEDIATE l_string;
496:
497: l_string := 'ANALYZE TABLE ' || l_pv_schema ||
498: '.pv_single_prod_h_mappings2 COMPUTE STATISTICS';
499: EXECUTE IMMEDIATE l_string;
500:
501: Debug('-');
502:

Line 552: FROM pv_single_prod_h_mappings2 b

548: l_update_ddl :=
549: 'UPDATE pv_selected_attr_values a
550: SET attribute_value =
551: (SELECT new_value
552: FROM pv_single_prod_h_mappings2 b
553: WHERE a.attr_value_id = b.attr_value_id)
554: WHERE EXISTS (SELECT 1
555: FROM pv_single_prod_h_mappings2 c
556: WHERE a.attr_value_id = c.attr_value_id)';

Line 555: FROM pv_single_prod_h_mappings2 c

551: (SELECT new_value
552: FROM pv_single_prod_h_mappings2 b
553: WHERE a.attr_value_id = b.attr_value_id)
554: WHERE EXISTS (SELECT 1
555: FROM pv_single_prod_h_mappings2 c
556: WHERE a.attr_value_id = c.attr_value_id)';
557:
558: l_string := SUBSTR(l_update_ddl, 1, 300);
559:

Line 595: p_token2_value => 'pv_single_prod_h_mappings2'

591: p_msg_name => 'PV_SPH_VIEW_MAPPING_TABLE',
592: p_token1 => 'TABLE1',
593: p_token1_value => 'pv_selected_attr_values',
594: p_token2 => 'TABLE2',
595: p_token2_value => 'pv_single_prod_h_mappings2'
596: );
597:
598: Debug('-');
599: Debug('SELECT old_value, new_value');

Line 600: Debug('FROM pv_single_prod_h_mappings2;');

596: );
597:
598: Debug('-');
599: Debug('SELECT old_value, new_value');
600: Debug('FROM pv_single_prod_h_mappings2;');
601: Debug('-');
602: Debug('-');
603:
604: