DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on FM_ROUT_HDR

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)

Line 923: FROM fm_rout_hdr

919: /*Bug#5618961 cursor modified to select routing qty and uom */
920: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)
921: IS
922: SELECT process_loss, routing_qty, routing_uom
923: FROM fm_rout_hdr
924: WHERE routing_id = v_routing_id;
925:
926: CURSOR class_process_loss_cursor (v_routing_class VARCHAR2, v_qty NUMBER)
927: IS