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_MAPPINGS

Line 144: 'INSERT INTO pv_single_prod_h_mappings

140: b.product_category_id IS NULL;
141:
142:
143: l_insert_into_table1 VARCHAR2(32000) :=
144: 'INSERT INTO pv_single_prod_h_mappings
145: SELECT a.enty_attr_val_id,
146: b.product_category_id new_value,
147: b.code old_value
148: FROM pv_enty_attr_values a,

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 245: FOR x IN (SELECT 'x' row_exists FROM pv_single_prod_h_mappings) LOOP

241: Set_Message(
242: p_msg_name => 'PV_SPH_REVERT_BACK'
243: );
244:
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

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 260: FROM pv_single_prod_h_mappings b

256: IF (l_revert_entity_attr) THEN
257: l_update_ddl :=
258: 'UPDATE pv_enty_attr_values a
259: SET attr_value = (SELECT old_value
260: FROM pv_single_prod_h_mappings b
261: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
262: WHERE EXISTS (SELECT 1
263: FROM pv_single_prod_h_mappings c
264: WHERE a.enty_attr_val_id = c.enty_attr_val_id)';

Line 263: FROM pv_single_prod_h_mappings c

259: SET attr_value = (SELECT old_value
260: FROM pv_single_prod_h_mappings b
261: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
262: WHERE EXISTS (SELECT 1
263: FROM pv_single_prod_h_mappings c
264: WHERE a.enty_attr_val_id = c.enty_attr_val_id)';
265:
266: l_string := SUBSTR(l_update_ddl, 1, 300);
267:

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 402: p_token1_value => 'pv_single_prod_h_mappings',

398:
399: Set_Message(
400: p_msg_name => 'PV_SPH_POPULATE_MAPPING',
401: p_token1 => 'TABLE1',
402: p_token1_value => 'pv_single_prod_h_mappings',
403: p_token2 => 'TABLE2',
404: p_token2_value => 'pv_enty_attr_values'
405: );
406:

Line 420: l_string := 'DROP INDEX ' || l_pv_schema || '.pv_single_prod_h_mappings_u1';

416: END LOOP;
417:
418:
419: BEGIN
420: l_string := 'DROP INDEX ' || l_pv_schema || '.pv_single_prod_h_mappings_u1';
421: EXECUTE IMMEDIATE l_string;
422:
423: EXCEPTION
424: WHEN OTHERS THEN

Line 428: l_string := 'TRUNCATE TABLE ' || l_pv_schema || '.pv_single_prod_h_mappings';

424: WHEN OTHERS THEN
425: null;
426: END;
427:
428: l_string := 'TRUNCATE TABLE ' || l_pv_schema || '.pv_single_prod_h_mappings';
429: EXECUTE IMMEDIATE l_string;
430:
431: l_string := SUBSTR(l_insert_into_table1, 1, 300);
432: EXECUTE IMMEDIATE l_insert_into_table1;

Line 443: '.pv_single_prod_h_mappings_u1 ' ||

439: p_token1_value => l_rows_inserted
440: );
441:
442: l_string := 'CREATE UNIQUE INDEX ' || l_pv_schema ||
443: '.pv_single_prod_h_mappings_u1 ' ||
444: 'ON pv_single_prod_h_mappings (enty_attr_val_id) ' ||
445: 'TABLESPACE ' || l_index_tablespace;
446: EXECUTE IMMEDIATE l_string;
447:

Line 444: 'ON pv_single_prod_h_mappings (enty_attr_val_id) ' ||

440: );
441:
442: l_string := 'CREATE UNIQUE INDEX ' || l_pv_schema ||
443: '.pv_single_prod_h_mappings_u1 ' ||
444: 'ON pv_single_prod_h_mappings (enty_attr_val_id) ' ||
445: 'TABLESPACE ' || l_index_tablespace;
446: EXECUTE IMMEDIATE l_string;
447:
448: l_string := 'ANALYZE TABLE ' || l_pv_schema ||

Line 449: '.pv_single_prod_h_mappings COMPUTE STATISTICS';

445: 'TABLESPACE ' || l_index_tablespace;
446: EXECUTE IMMEDIATE l_string;
447:
448: l_string := 'ANALYZE TABLE ' || l_pv_schema ||
449: '.pv_single_prod_h_mappings COMPUTE STATISTICS';
450: EXECUTE IMMEDIATE l_string;
451:
452:
453:

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 518: FROM pv_single_prod_h_mappings b

514:
515: l_update_ddl :=
516: 'UPDATE pv_enty_attr_values a
517: SET attr_value = (SELECT new_value
518: FROM pv_single_prod_h_mappings b
519: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
520: WHERE EXISTS (SELECT 1
521: FROM pv_single_prod_h_mappings c
522: WHERE a.enty_attr_val_id = c.enty_attr_val_id)';

Line 521: FROM pv_single_prod_h_mappings c

517: SET attr_value = (SELECT new_value
518: FROM pv_single_prod_h_mappings b
519: WHERE a.enty_attr_val_id = b.enty_attr_val_id)
520: WHERE EXISTS (SELECT 1
521: FROM pv_single_prod_h_mappings c
522: WHERE a.enty_attr_val_id = c.enty_attr_val_id)';
523:
524: l_string := SUBSTR(l_update_ddl, 1, 300);
525:

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 581: p_token2_value => 'pv_single_prod_h_mappings'

577: p_msg_name => 'PV_SPH_VIEW_MAPPING_TABLE',
578: p_token1 => 'TABLE1',
579: p_token1_value => 'pv_enty_attr_values',
580: p_token2 => 'TABLE2',
581: p_token2_value => 'pv_single_prod_h_mappings'
582: );
583:
584: Debug('-');
585: Debug('SELECT old_value, new_value');

Line 586: Debug('FROM pv_single_prod_h_mappings;');

582: );
583:
584: Debug('-');
585: Debug('SELECT old_value, new_value');
586: Debug('FROM pv_single_prod_h_mappings;');
587: Debug('-');
588: Debug('-');
589:
590: Set_Message(

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: