APPS.GMO_INSTR_ENTITY_PVT dependencies on GMD_ROUTINGS

Line 43: from gmd_operations a, fm_rout_dtl b, gmd_routings c

39: where oprn_id = l_oprn_id;
40:
41: cursor get_routing_oprn is
42: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || routingstep_no || '-' || oprn_no
43: from gmd_operations a, fm_rout_dtl b, gmd_routings c
44: where a.oprn_id = b.oprn_id
45: and c.routing_id = b.routing_id
46: and b.routingstep_id = l_routingstep_id
47: and a.oprn_id = l_oprn_id;

Line 62: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d

58: select activity from gmd_operation_activities where oprn_line_id = l_oprn_line_id;
59:
60: cursor get_routing_activity is
61: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || d.activity
62: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d
63: where a.oprn_id = b.oprn_id
64: and c.routing_id = b.routing_id
65: and a.oprn_id = d.oprn_id
66: and d.oprn_line_id = l_oprn_line_id

Line 87: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d, gmd_operation_resources e

83:
84: cursor get_routing_resource is
85:
86: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || e.resources
87: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d, gmd_operation_resources e
88: where a.oprn_id = b.oprn_id
89: and c.routing_id = b.routing_id
90: and a.oprn_id = d.oprn_id
91: and d.oprn_line_id = e.oprn_line_id