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_COMMON_VAL dependencies on FM_ROUT_HDR

Line 512: /* Step1 - Based on the routing_id get the routing_class from fm_rout_hdr */

508: /* e.g No routing class is associated with the routing */
509: /* Returns S if process loss is calculated and status is success */
510: /* Returns U if unexpected error occurs */
511: /* */
512: /* Step1 - Based on the routing_id get the routing_class from fm_rout_hdr */
513: /* Step2 - Based on routing_class get the UOM from fm_rout_cls table */
514: /* Step3 - Check if recipe uom can be converted to this UOM and convert */
515: /* total product qty to this UOM */
516: /* Step4 - Get the process loss from gmd_process_loss table. */

Line 552: l_routing_class fm_rout_hdr.routing_class%TYPE;

548: l_recipe_qty NUMBER;
549: l_ing_qty NUMBER;
550: l_uom VARCHAR2(4);
551: l_item_um VARCHAR2(3);
552: l_routing_class fm_rout_hdr.routing_class%TYPE;
553: l_routing_uom fm_rout_cls.UOM%TYPE;
554: l_routing_qty fm_rout_hdr.routing_qty%TYPE;
555: l_routing_planned_loss NUMBER;
556: l_routing_theo_loss NUMBER;

Line 554: l_routing_qty fm_rout_hdr.routing_qty%TYPE;

550: l_uom VARCHAR2(4);
551: l_item_um VARCHAR2(3);
552: l_routing_class fm_rout_hdr.routing_class%TYPE;
553: l_routing_uom fm_rout_cls.UOM%TYPE;
554: l_routing_qty fm_rout_hdr.routing_qty%TYPE;
555: l_routing_planned_loss NUMBER;
556: l_routing_theo_loss NUMBER;
557: l_routing_prorate_factor NUMBER := 1;
558: l_recipe_prorate_factor NUMBER := 1;

Line 587: Cursor Rout_cls_cur(vRouting_class fm_rout_hdr.routing_class%TYPE) IS

583: Where routing_id = vRouting_id
584: and delete_mark = 0;
585:
586: --Bug 6871738. Select ROUTING_CLASS_UOM instead of UOM.
587: Cursor Rout_cls_cur(vRouting_class fm_rout_hdr.routing_class%TYPE) IS
588: Select ROUTING_CLASS_UOM
589: From fm_rout_cls
590: Where routing_class = vRouting_class
591: and delete_mark = 0;

Line 1805: FROM fm_rout_hdr

1801: ELSIF (Entity = 'ROUTING') THEN
1802:
1803: SELECT delete_mark, routing_status
1804: INTO l_delete_mark, l_status_code
1805: FROM fm_rout_hdr
1806: WHERE routing_id = Entity_id;
1807: ELSIF (Entity = 'OPERATION') THEN
1808: SELECT delete_mark, operation_status
1809: INTO l_delete_mark, l_status_code

Line 1946: From fm_rout_hdr r, gmd_status s

1942: FETCH get_routing_owner_orgn_id INTO l_orgn_id;
1943: CLOSE get_routing_owner_orgn_id;
1944: OPEN Status_cur FOR
1945: Select r.routing_status, s.version_enabled
1946: From fm_rout_hdr r, gmd_status s
1947: Where r.routing_id = Entity_id
1948: And r.routing_status = s.status_code;
1949: FETCH Status_cur INTO l_status, l_version_enabled;
1950: ClOSE Status_cur;