APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 50: l_inventory_item_name mtl_system_items_b_kfv.concatenated_segments%type := null;

46: l_material_issue_by_mo varchar2(1);
47: l_project_id number := null;
48: l_task_id number := null;
49: l_issue_by_mo boolean := true;
50: l_inventory_item_name mtl_system_items_b_kfv.concatenated_segments%type := null;
51: l_quantity Number;
52: l_primary_uom_code mtl_system_items_b_kfv.primary_uom_code%type;
53: l_serial_number_control_code Number;
54: l_lot_control_code Number;

Line 52: l_primary_uom_code mtl_system_items_b_kfv.primary_uom_code%type;

48: l_task_id number := null;
49: l_issue_by_mo boolean := true;
50: l_inventory_item_name mtl_system_items_b_kfv.concatenated_segments%type := null;
51: l_quantity Number;
52: l_primary_uom_code mtl_system_items_b_kfv.primary_uom_code%type;
53: l_serial_number_control_code Number;
54: l_lot_control_code Number;
55: l_reason_id Number;
56: x_err_flag Number;

Line 152: from mtl_system_items_b_kfv

148: l_primary_uom_code ,
149: l_serial_number_control_code,
150: l_lot_control_code,
151: l_material
152: from mtl_system_items_b_kfv
153: where inventory_item_id=p_inventory_item_id
154: and organization_id=p_organization_id;
155:
156: l_inventory_item_id:=p_inventory_item_id;

Line 335: from mtl_system_items_b_kfv msi, mtl_parameters mp

331: begin
332: l_rebuild_item_id := p_rebuild_item_id;
333: if (p_rebuild_item_id is null) then
334: select msi.inventory_item_id into l_rebuild_item_id
335: from mtl_system_items_b_kfv msi, mtl_parameters mp
336: where concatenated_segments = p_rebuild_item_name
337: and msi.organization_id = mp.organization_id
338: and mp.maint_organization_id = p_organization_id
339: and eam_item_type = 3 --3 for rebuild

Line 365: from mtl_system_items_b_kfv

361: begin
362: l_rebuild_activity_id := p_rebuild_activity_id;
363: if (p_rebuild_activity_id is null) then -- activity name must be non null
364: select inventory_item_id into l_rebuild_activity_id
365: from mtl_system_items_b_kfv
366: where concatenated_segments = p_rebuild_activity_name
367: and organization_id = p_organization_id
368: and eam_item_type = 2; --2 for activity
369: end if;