[Home] [Help]
38: select oprn_no from gmd_operations
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;
48:
49: cursor get_recipe_oprn is
50:
51: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || b.routingstep_no || '-' || a.oprn_no
52: from gmd_operations a, fm_rout_dtl b, gmd_recipes c
53: where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id
54: and c.recipe_id = l_recipe_id and b.routingstep_id = l_routingstep_id and a.oprn_id = l_oprn_id;
55:
57: cursor get_activity is
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
67: and b.routingstep_id = l_routingstep_id;
68:
69: cursor get_recipe_activity is
70: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || d.activity
71: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d
72: where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id and a.oprn_id = d.oprn_id
73: and b.routingstep_id = l_routingstep_id
74: and c.recipe_id = l_recipe_id
82: and b.resources = l_resources;
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
93: and d.oprn_line_id = l_oprn_line_id
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
103: and e.resources = l_resources;
104:
105: cursor get_formula_material is
106: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'FORMULA') || ' ' || c.formula_no || ' : ' || b.Concatenated_segments
107: from fm_matl_dtl a, mtl_system_items_kfv b, fm_form_mst c
108: where a.inventory_item_id = b.inventory_item_id
109: and a.organization_id = b.organization_id
110: and a.formula_id = c.formula_id
111: and a.inventory_item_id = l_inventory_item_id
112: and a.formulaline_id = l_formulaline_id;
113:
114: cursor get_recipe_material is
115: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || b.Concatenated_segments
116: from fm_matl_dtl a, mtl_system_items_kfv b, gmd_recipes c
117: where a.inventory_item_id = b.inventory_item_id
118: and a.organization_id=b.organization_id
119: and a.formula_id = c.formula_id
126: from mtl_system_items_kfv a
127: where a.inventory_item_id = l_inventory_item_id;
128:
129: cursor get_org_dispense_item is
130: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ORGANIZATION') || ' ' || b.organization_code || ' : ' || a.Concatenated_segments
131: from mtl_system_items_kfv a, mtl_parameters b
132: where a.organization_id=b.organization_id
133: and a.inventory_item_id = l_inventory_item_id
134: and a.organization_id = l_organization_id;
134: and a.organization_id = l_organization_id;
135:
136:
137: cursor get_recipe_dispense_item is
138: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || a.Concatenated_segments
139: from mtl_system_items_kfv a, mtl_parameters b, gmd_recipes c, fm_matl_dtl d
140: where a.organization_id=b.organization_id
141: and d.formula_id = c.formula_id
142: and d.inventory_item_id = a.inventory_item_id