DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on FM_ROUT_HDR

Line 993: FROM fm_rout_hdr a, gmd_routing_class_b b

989: CURSOR cur_get_rtclass (v_routing_id NUMBER)
990: IS
991: SELECT a.routing_class,routing_uom, b.routing_class_uom, --item_um
992: process_loss, routing_qty
993: FROM fm_rout_hdr a, gmd_routing_class_b b
994: WHERE a.routing_id = v_routing_id
995: AND a.routing_class = b.routing_class (+);
996:
997: CURSOR orgn_process_loss_cursor (v_recipe_id NUMBER, v_org_id NUMBER)

Line 1013: FROM fm_rout_hdr

1009: /*Bug#5618961 cursor modified to select routing qty and uom */
1010: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)
1011: IS
1012: SELECT process_loss, routing_qty, routing_uom
1013: FROM fm_rout_hdr
1014: WHERE routing_id = v_routing_id;
1015:
1016: CURSOR class_process_loss_cursor (v_routing_class VARCHAR2, v_qty NUMBER)
1017: IS