APPS.GMO_INSTR_ENTITY_PVT dependencies on GMD_OPERATION_RESOURCES

Line 79: from gmd_operation_activities a, gmd_operation_resources b

75: and d.oprn_line_id = l_oprn_line_id;
76:
77: cursor get_resource is
78: select b.resources
79: from gmd_operation_activities a, gmd_operation_resources b
80: where a.oprn_line_id = b.oprn_line_id
81: and a.oprn_line_id = l_oprn_line_id
82: and b.resources = l_resources;
83:

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

Line 98: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d, gmd_operation_resources e

94: and e.resources = l_resources;
95:
96: cursor get_recipe_resource is
97: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || e.resources
98: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d, gmd_operation_resources e
99: where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id and a.oprn_id = d.oprn_id and d.oprn_line_id = e.oprn_line_id
100: and c.recipe_id = l_recipe_id
101: and b.routingstep_id = l_routingstep_id
102: and e.oprn_line_id = l_oprn_line_id