APPS.GMO_VBATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 254: 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;

250: l_msg_data varchar2(4000);
251: k number;
252:
253: 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;
254: 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;
255: BEGIN
256:
257: open c_get_batch_details;
258: fetch c_get_batch_details into l_batch_id, l_organization_id;

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

782: l_batch_operation varchar2(1000);
783:
784: cursor get_batchstep_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
785: cursor get_batchstep_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
786: cursor get_batchstep_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
787:
788: NO_BATCHSTEP_FOUND_ERR exception;
789:
790: BEGIN

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

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

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

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

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;
2078:
2079: cursor c_get_step_material is select material_detail_id from gme_batch_step_items where batchstep_id = p_entity_key;
2080:
2081: cursor c_get_activity_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;
2082:
2083:

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

2699: 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;
2700:
2701: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2702: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2703: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2704:
2705: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2706:
2707: no_step_found_err exception;

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

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;