[Home] [Help]
127: RAISE MATERIAL_RESERVATION_ERR;
128: end if;
129:
130: --Bug 4609365: start
131: select dtl_um into l_detail_uom from gme_material_details where material_detail_id = P_MATERIAL_DETAIL_ID;
132: --Bug 4609365: end
133:
134: for i in 1 .. l_reservation_tbl.count loop
135: --Bug 4609365: start
231: BEGIN
232:
233: SELECT actual_qty ,line_type
234: INTO l_actual_quantity,l_line_type
235: FROM gme_material_details
236: WHERE material_detail_id=P_MATERIAL_DETAIL_ID
237: AND inventory_item_id= P_INVENTORY_ITEM_ID;
238:
239: OPEN c_transaction_qty(P_INVENTORY_ITEM_ID,P_MATERIAL_DETAIL_ID);
736:
737: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
738: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
739: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
740: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
741:
742: NO_BATCH_FOUND_ERR exception;
743:
744: BEGIN
962:
963: cursor get_param is select process_param_id from gme_process_parameters where batchstep_resource_id = l_batchstep_resource_id and parameter_id = l_param_id;
964: cursor get_min_param is select (process_param_id) from gme_process_parameters where batchstep_resource_id = l_batchstep_resource_id;
965:
966: cursor get_material is select material_detail_id from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
967: cursor get_min_material_for_step is select min(material_detail_id) from gme_batch_step_items where batchstep_id = l_batchstep_id;
968:
969: cursor get_instr_details is select instr_number, instruction_id, task_id, task_attribute_id from gmo_instr_instance_b where instruction_set_id = P_INSTRUCTION_SET_ID;
970:
1221: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1222: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1223:
1224: cursor c_get_materials is
1225: select a.material_detail_id, a.formulaline_id, a.inventory_item_id, b.concatenated_segments from gme_material_details a, mtl_system_items_kfv b
1226: where a.organization_id = b.organization_id
1227: and a.inventory_item_id = b.inventory_item_id
1228: and a.batch_id = p_entity_key;
1229:
1606: cursor get_param_detail is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id, process_param_id from gme_process_parameters where batchstep_resource_id = l_batchstep_resource_id and parameter_id = l_param_id;
1607: cursor get_param_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id, process_param_id from gme_process_parameters where process_param_id = l_process_param_id;
1608:
1609:
1610: cursor get_material_detail is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
1611: cursor get_material_detail_from_id is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where material_detail_id = l_material_detail_id;
1612: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1613:
1614: cursor get_org_detail is select a.organization_id, a.organization_code from mtl_parameters a, gme_batch_header b where a.organization_id = b.organization_id and b.batch_id = l_batch_id;
1607: cursor get_param_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id, process_param_id from gme_process_parameters where process_param_id = l_process_param_id;
1608:
1609:
1610: cursor get_material_detail is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
1611: cursor get_material_detail_from_id is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where material_detail_id = l_material_detail_id;
1612: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1613:
1614: cursor get_org_detail is select a.organization_id, a.organization_code from mtl_parameters a, gme_batch_header b where a.organization_id = b.organization_id and b.batch_id = l_batch_id;
1615:
2114: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2115:
2116: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2117:
2118: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;
2119:
2120:
2121: cursor c_get_step_activities is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = p_entity_key;
2122: cursor c_get_step_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_id = p_entity_key;
2919: gme_batch_step_resources where batchstep_id=P_BATCHSTEP_ID and batch_id =
2920: P_BATCH_ID and batchstep_activity_id = l_batchstep_activity_id;
2921:
2922: cursor c_get_material is select e.Concatenated_segments, a.material_detail_id
2923: from gme_material_details a, gme_batch_step_items b, MTL_SYSTEM_ITEMS_KFV e
2924: where a.material_detail_id = b.material_detail_id
2925: and (a.inventory_item_id = e.inventory_item_id and a.organization_id =
2926: e.organization_id)
2927: and b.batchstep_id = P_BATCHSTEP_ID and a.batch_id = P_BATCH_ID;