APPS.GMO_VBATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 299: cursor c_is_material_reqd_for_step is select count(*) from gme_batch_step_items where material_detail_id = l_material_detail_id and batchstep_id = p_batchstep_id;

295: l_msg_data varchar2(4000);
296: k number;
297:
298: cursor c_get_batch_details is select a.batch_id, a.organization_id from gme_batch_header a, gme_batch_steps b where a.batch_id = b.batch_id and b.batchstep_id = p_batchstep_id;
299: cursor c_is_material_reqd_for_step is select count(*) from gme_batch_step_items where material_detail_id = l_material_detail_id and batchstep_id = p_batchstep_id;
300: BEGIN
301:
302: open c_get_batch_details;
303: fetch c_get_batch_details into l_batch_id, l_organization_id;

Line 831: cursor get_batchstep_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;

827: l_batch_operation varchar2(1000);
828:
829: cursor get_batchstep_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
830: cursor get_batchstep_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
831: cursor get_batchstep_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
832:
833: NO_BATCHSTEP_FOUND_ERR exception;
834:
835: BEGIN

Line 967: cursor get_min_material_for_step is select min(material_detail_id) from gme_batch_step_items where batchstep_id = l_batchstep_id;

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:
971: cursor get_task is select task_name from gmo_instr_task_defn_b where task_id = l_task_id;

Line 1612: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_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:
1616: GMO_INVALID_TASK_ERR exception;

Line 2124: cursor c_get_step_material is select material_detail_id from gme_batch_step_items where batchstep_id = p_entity_key;

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;
2123:
2124: cursor c_get_step_material is select material_detail_id from gme_batch_step_items where batchstep_id = p_entity_key;
2125:
2126: cursor c_get_activity_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;
2127:
2128:

Line 2748: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;

2744: cursor is_step_locked_by is select count(*) from gmo_batch_step_lock_details where batchstep_id = l_batchstep_id and lock_requester = P_REQUESTER;
2745:
2746: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2747: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2748: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2749:
2750: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2751:
2752: no_step_found_err exception;

Line 2923: from gme_material_details a, gme_batch_step_items b, MTL_SYSTEM_ITEMS_KFV e

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;