DBA Data[Home] [Help]

APPS.GMD_PROCESS_INSTR_UTILS dependencies on FM_ROUT_DTL

Line 31: FROM fm_rout_dtl r, gmd_operations_b o

27:
28: /* Cursor to fetch routing details */
29: CURSOR Get_routing_details (v_routing_id NUMBER) IS
30: SELECT r.routingstep_id, r.routingstep_no, r.oprn_id, o.oprn_no
31: FROM fm_rout_dtl r, gmd_operations_b o
32: WHERE r.routing_id = v_routing_id
33: AND r.oprn_id = o.oprn_id
34: ORDER BY r.routingstep_no;
35:

Line 742: FROM fm_rout_dtl r

738: ORDER BY resources;
739:
740: CURSOR Get_routingstep_details(v_routingstep_id NUMBER) IS
741: SELECT r.routingstep_id,r.oprn_id
742: FROM fm_rout_dtl r
743: WHERE r.routingstep_id = v_routingstep_id;
744:
745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;