DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GMD_ROUTING_CLASS_B

Line 903: FROM fm_rout_hdr a, gmd_routing_class_b b

899: CURSOR cur_get_rtclass (v_routing_id NUMBER)
900: IS
901: SELECT a.routing_class,routing_uom, b.routing_class_uom, --item_um
902: process_loss, routing_qty
903: FROM fm_rout_hdr a, gmd_routing_class_b b
904: WHERE a.routing_id = v_routing_id
905: AND a.routing_class = b.routing_class (+);
906:
907: CURSOR orgn_process_loss_cursor (v_recipe_id NUMBER, v_org_id NUMBER)