APPS.GMO_INSTR_ENTITY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

	select oprn_no from gmd_operations
	where oprn_id  = l_oprn_id;

Line: 42

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : '  ||  routingstep_no || '-' || oprn_no
	from gmd_operations a, fm_rout_dtl b, gmd_routings c
	where a.oprn_id = b.oprn_id
	and c.routing_id = b.routing_id
	and b.routingstep_id = l_routingstep_id
	and a.oprn_id = l_oprn_id;

Line: 51

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || b.routingstep_no || '-' || a.oprn_no
	from gmd_operations a, fm_rout_dtl b, gmd_recipes c
	where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id
	and c.recipe_id = l_recipe_id and b.routingstep_id = l_routingstep_id and a.oprn_id = l_oprn_id;

Line: 58

	select activity from gmd_operation_activities where oprn_line_id = l_oprn_line_id;

Line: 61

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : '  || d.activity
	from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d
	where a.oprn_id = b.oprn_id
	and c.routing_id = b.routing_id
	and a.oprn_id = d.oprn_id
	and d.oprn_line_id = l_oprn_line_id
	and b.routingstep_id = l_routingstep_id;

Line: 70

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' ||  d.activity
	from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d
	where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id and a.oprn_id = d.oprn_id
	and b.routingstep_id = l_routingstep_id
	and c.recipe_id = l_recipe_id
	and d.oprn_line_id = l_oprn_line_id;

Line: 78

	select b.resources
	from gmd_operation_activities a, gmd_operation_resources b
	where a.oprn_line_id = b.oprn_line_id
	and a.oprn_line_id = l_oprn_line_id
	and b.resources = l_resources;

Line: 86

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || e.resources
	from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d, gmd_operation_resources e
	where a.oprn_id = b.oprn_id
	and c.routing_id = b.routing_id
	and a.oprn_id = d.oprn_id
	and d.oprn_line_id = e.oprn_line_id
	and b.routingstep_id = l_routingstep_id
	and d.oprn_line_id = l_oprn_line_id
	and e.resources = l_resources;

Line: 97

	select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' ||  e.resources
	from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d, gmd_operation_resources e
	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
	and c.recipe_id = l_recipe_id
	and b.routingstep_id = l_routingstep_id
	and e.oprn_line_id = l_oprn_line_id
	and e.resources = l_resources;

Line: 106

	Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'FORMULA') || ' ' || c.formula_no || ' : ' || b.Concatenated_segments
	from fm_matl_dtl a, mtl_system_items_kfv b, fm_form_mst c
	where a.inventory_item_id = b.inventory_item_id
	and a.organization_id = b.organization_id
	and a.formula_id = c.formula_id
	and a.inventory_item_id = l_inventory_item_id
	and a.formulaline_id = l_formulaline_id;

Line: 115

	Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || b.Concatenated_segments
	from fm_matl_dtl a, mtl_system_items_kfv b, gmd_recipes c
	where a.inventory_item_id = b.inventory_item_id
	and a.organization_id=b.organization_id
	and a.formula_id = c.formula_id
	and a.inventory_item_id = l_inventory_item_id
	and a.formulaline_id = l_formulaline_id
	and c.recipe_id = l_recipe_id;

Line: 125

	Select a.Concatenated_segments
	from mtl_system_items_kfv a
	where a.inventory_item_id = l_inventory_item_id;

Line: 130

	Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ORGANIZATION') || ' ' || b.organization_code || ' : ' || a.Concatenated_segments
	from mtl_system_items_kfv a, mtl_parameters b
	where a.organization_id=b.organization_id
	and a.inventory_item_id = l_inventory_item_id
	and a.organization_id = l_organization_id;

Line: 138

	Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || a.Concatenated_segments
	from mtl_system_items_kfv a, mtl_parameters b, gmd_recipes c, fm_matl_dtl d
	where a.organization_id=b.organization_id
	and d.formula_id = c.formula_id
	and d.inventory_item_id = a.inventory_item_id
	and a.inventory_item_id = l_inventory_item_id
	and a.organization_id = l_organization_id
	and c.recipe_id = l_recipe_id;

Line: 148

        select inventory_item_id,
               organization_id,
               recipe_id
        from   gmo_dispense_config
        where  config_id = to_number(p_entity_key,'999999999999.999999');

Line: 327

cursor get_task_name is select task_name from gmo_instr_task_defn_b where task_id = P_TASK_ID;

Line: 329

cursor get_old_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_source_oprn_id order by oprn_line_id;

Line: 330

cursor get_new_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_target_oprn_id order by oprn_line_id;

Line: 421

procedure UPDATE_TASK_ATTRIBUTE
(
P_INSTRUCTION_PROCESS_ID IN NUMBER,
P_INSTRUCTION_SET_ID IN NUMBER,
P_ENTITY_NAME IN VARCHAR2,
P_SOURCE_ENTITY_KEY IN VARCHAR2,
P_TARGET_ENTITY_KEY IN VARCHAR2
)
IS
l_instruction_id number;

Line: 435

cursor get_instr_details is select instruction_id, task_id, task_attribute_id from gmo_instr_defn_t where instruction_process_id = P_INSTRUCTION_PROCESS_ID and instruction_set_id=P_INSTRUCTION_SET_ID;

Line: 454

				update gmo_instr_defn_t set task_attribute_id = l_new_task_attribute_id
				where instruction_process_id = P_INSTRUCTION_PROCESS_ID and instruction_id = l_instruction_id;

Line: 461

END UPDATE_TASK_ATTRIBUTE;