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.GMD_PROC_PARAMS_MIGR dependencies on GMD_RECIPE_PROCESS_PARAMETERS

Line 559: /* Insert process parameter 1 value into GMD_RECIPE_PROCESS_PARAMETERS table */

555: recipe_id,routingstep_id,orgn_code
556: FROM gmd_recipe_orgn_resources;
557: BEGIN
558: FOR l_rec IN Cur_recipe_parameters LOOP
559: /* Insert process parameter 1 value into GMD_RECIPE_PROCESS_PARAMETERS table */
560: IF l_rec.process_parameter_1 IS NOT NULL THEN
561: /*Check if the row for the resource already exists if it does not then*/
562: INSERT INTO gmd_recipe_process_parameters
563: (oprn_line_id,

Line 562: INSERT INTO gmd_recipe_process_parameters

558: FOR l_rec IN Cur_recipe_parameters LOOP
559: /* Insert process parameter 1 value into GMD_RECIPE_PROCESS_PARAMETERS table */
560: IF l_rec.process_parameter_1 IS NOT NULL THEN
561: /*Check if the row for the resource already exists if it does not then*/
562: INSERT INTO gmd_recipe_process_parameters
563: (oprn_line_id,
564: resources,
565: recipe_id,
566: routingstep_id,

Line 590: FROM gmd_recipe_process_parameters

586: 0,
587: 0
588: FROM DUAL
589: WHERE NOT EXISTS (SELECT 1
590: FROM gmd_recipe_process_parameters
591: WHERE oprn_line_id = l_rec.oprn_line_id
592: AND resources = l_rec.resources
593: AND orgn_code = l_rec.orgn_code
594: AND recipe_id = l_rec.recipe_id

Line 601: INSERT INTO gmd_recipe_process_parameters

597: END IF; /*IF l_rec.process_parameter_1 IS NOT NULL THEN*/
598:
599: IF l_rec.process_parameter_2 IS NOT NULL THEN
600: /*Check if the row for the resource already exists if it does not then*/
601: INSERT INTO gmd_recipe_process_parameters
602: (oprn_line_id,
603: resources,
604: recipe_id,
605: routingstep_id,

Line 629: FROM gmd_recipe_process_parameters

625: 0,
626: 0
627: FROM DUAL
628: WHERE NOT EXISTS (SELECT 1
629: FROM gmd_recipe_process_parameters
630: WHERE oprn_line_id = l_rec.oprn_line_id
631: AND resources = l_rec.resources
632: AND orgn_code = l_rec.orgn_code
633: AND recipe_id = l_rec.recipe_id

Line 640: INSERT INTO gmd_recipe_process_parameters

636: END IF; /*IF l_rec.process_parameter_2 IS NOT NULL THEN*/
637:
638: IF l_rec.process_parameter_3 IS NOT NULL THEN
639: /*Check if the row for the resource already exists if it does not then*/
640: INSERT INTO gmd_recipe_process_parameters
641: (oprn_line_id,
642: resources,
643: recipe_id,
644: routingstep_id,

Line 668: FROM gmd_recipe_process_parameters

664: 0,
665: 0
666: FROM DUAL
667: WHERE NOT EXISTS (SELECT 1
668: FROM gmd_recipe_process_parameters
669: WHERE oprn_line_id = l_rec.oprn_line_id
670: AND resources = l_rec.resources
671: AND orgn_code = l_rec.orgn_code
672: AND recipe_id = l_rec.recipe_id

Line 679: INSERT INTO gmd_recipe_process_parameters

675: END IF; /*IF l_rec.process_parameter_3 IS NOT NULL THEN*/
676:
677: IF l_rec.process_parameter_4 IS NOT NULL THEN
678: /*Check if the row for the resource already exists if it does not then*/
679: INSERT INTO gmd_recipe_process_parameters
680: (oprn_line_id,
681: resources,
682: recipe_id,
683: routingstep_id,

Line 707: FROM gmd_recipe_process_parameters

703: 0,
704: 0
705: FROM DUAL
706: WHERE NOT EXISTS (SELECT 1
707: FROM gmd_recipe_process_parameters
708: WHERE oprn_line_id = l_rec.oprn_line_id
709: AND resources = l_rec.resources
710: AND orgn_code = l_rec.orgn_code
711: AND recipe_id = l_rec.recipe_id

Line 718: INSERT INTO gmd_recipe_process_parameters

714: END IF; /*IF l_rec.process_parameter_4 IS NOT NULL THEN*/
715:
716: IF l_rec.process_parameter_5 IS NOT NULL THEN
717: /*Check if the row for the resource already exists if it does not then*/
718: INSERT INTO gmd_recipe_process_parameters
719: (oprn_line_id,
720: resources,
721: recipe_id,
722: routingstep_id,

Line 746: FROM gmd_recipe_process_parameters

742: 0,
743: 0
744: FROM DUAL
745: WHERE NOT EXISTS (SELECT 1
746: FROM gmd_recipe_process_parameters
747: WHERE oprn_line_id = l_rec.oprn_line_id
748: AND resources = l_rec.resources
749: AND orgn_code = l_rec.orgn_code
750: AND recipe_id = l_rec.recipe_id

Line 759: ,p_table_name => 'GMD_RECIPE_PROCESS_PARAMETERS'

755: EXCEPTION
756: WHEN OTHERS THEN
757: P_line_no := P_line_no + 1;
758: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
759: ,p_table_name => 'GMD_RECIPE_PROCESS_PARAMETERS'
760: ,p_db_error => sqlerrm
761: ,p_param1 => NULL
762: ,p_param2 => NULL
763: ,p_param3 => NULL

Line 991: FROM gmd_recipe_process_parameters

987: SELECT DISTINCT resources,Parameter_id
988: FROM gmd_oprn_process_parameters
989: UNION
990: SELECT DISTINCT resources,Parameter_id
991: FROM gmd_recipe_process_parameters
992: UNION
993: SELECT DISTINCT resources,Parameter_id
994: FROM gme_process_parameters
995: order by 1;

Line 1005: FROM gmd_recipe_process_parameters

1001: AND parameter_id = V_parameter_id
1002: GROUP BY Target_Value
1003: UNION
1004: SELECT Target_Value, COUNT(1)
1005: FROM gmd_recipe_process_parameters
1006: WHERE resources = V_resources
1007: AND parameter_id = V_parameter_id
1008: GROUP BY Target_Value
1009: UNION