APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

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

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

Line 54: l_primary_uom_code mtl_system_items_b_kfv.primary_uom_code%type;

50: l_task_id number := null;
51: l_issue_by_mo boolean := true;
52: l_inventory_item_name mtl_system_items_b_kfv.concatenated_segments%type := null;
53: l_quantity Number;
54: l_primary_uom_code mtl_system_items_b_kfv.primary_uom_code%type;
55: l_serial_number_control_code Number;
56: l_revision_qty_control_code NUMBER;
57: l_lot_control_code Number;
58: l_onhand_quantity NUMBER;

Line 94: l_material mtl_system_items_b_kfv.concatenated_segments%TYPE;

90: l_tx_count number := 0;
91: l_txmgr_ret_code number := -1;
92: l_num_valid_serials number;
93: l_num_range_serials number;
94: l_material mtl_system_items_b_kfv.concatenated_segments%TYPE;
95: l_neg_inv_receipt_code number;
96: l_within_open_period varchar2(1):= 'N';
97: l_inventory_item_id_wl Number; --8667921/8661513 to derive the inventory_item_id for wireless application
98: l_source_locator_wl Number; --8667921/8661513 to derive the inventory_item_id for wireless application

Line 203: from mtl_system_items_b_kfv

199: l_serial_number_control_code,
200: l_lot_control_code,
201: l_material,
202: l_revision_qty_control_code
203: from mtl_system_items_b_kfv
204: where inventory_item_id= nvl(p_inventory_item_id,l_inventory_item_id_wl) --bug 8661513
205: and organization_id=p_organization_id;
206:
207: l_inventory_item_id:= nvl(p_inventory_item_id,l_inventory_item_id_wl); --bug 8661513

Line 544: from mtl_system_items_b_kfv msi, mtl_parameters mp

540: begin
541: l_rebuild_item_id := nvl(p_rebuild_item_id,l_rebuild_item_id_wl); --changed for bug 8661513
542: if (nvl(p_rebuild_item_id,l_rebuild_item_id_wl) is null) then --changed for bug 8661513
543: select msi.inventory_item_id into l_rebuild_item_id
544: from mtl_system_items_b_kfv msi, mtl_parameters mp
545: where concatenated_segments = p_rebuild_item_name
546: and msi.organization_id = mp.organization_id
547: and mp.maint_organization_id = p_organization_id
548: and eam_item_type = 3 --3 for rebuild

Line 574: from mtl_system_items_b_kfv

570: begin
571: l_rebuild_activity_id := p_rebuild_activity_id;
572: if (p_rebuild_activity_id is null) then -- activity name must be non null
573: select inventory_item_id into l_rebuild_activity_id
574: from mtl_system_items_b_kfv
575: where concatenated_segments = p_rebuild_activity_name
576: and organization_id = p_organization_id
577: and eam_item_type = 2; --2 for activity
578: end if;