[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
691:
692: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
693: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
694: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
695: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
696:
697: NO_BATCH_FOUND_ERR exception;
698:
699: BEGIN
917:
918: 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;
919: cursor get_min_param is select (process_param_id) from gme_process_parameters where batchstep_resource_id = l_batchstep_resource_id;
920:
921: 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;
922: cursor get_min_material_for_step is select min(material_detail_id) from gme_batch_step_items where batchstep_id = l_batchstep_id;
923:
924: 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;
925:
1176: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1177: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1178:
1179: cursor c_get_materials is
1180: 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
1181: where a.organization_id = b.organization_id
1182: and a.inventory_item_id = b.inventory_item_id
1183: and a.batch_id = p_entity_key;
1184:
1561: 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;
1562: 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;
1563:
1564:
1565: 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;
1566: 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;
1567: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1568:
1569: 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;
1562: 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;
1563:
1564:
1565: 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;
1566: 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;
1567: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1568:
1569: 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;
1570:
2069: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2070:
2071: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2072:
2073: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;
2074:
2075:
2076: cursor c_get_step_activities is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = p_entity_key;
2077: cursor c_get_step_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_id = p_entity_key;
2874: gme_batch_step_resources where batchstep_id=P_BATCHSTEP_ID and batch_id =
2875: P_BATCH_ID and batchstep_activity_id = l_batchstep_activity_id;
2876:
2877: cursor c_get_material is select e.Concatenated_segments, a.material_detail_id
2878: from gme_material_details a, gme_batch_step_items b, MTL_SYSTEM_ITEMS_KFV e
2879: where a.material_detail_id = b.material_detail_id
2880: and (a.inventory_item_id = e.inventory_item_id and a.organization_id =
2881: e.organization_id)
2882: and b.batchstep_id = P_BATCHSTEP_ID and a.batch_id = P_BATCH_ID;