APPS.INV_TRANSACTION_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 93: from mtl_system_items_kfv

89: select concatenated_segments, inventory_item_id, description,
90: revision_qty_control_code, lot_control_code, location_control_code,
91: serial_number_control_code, restrict_subinventories_code,
92: restrict_locators_code
93: from mtl_system_items_kfv
94: where organization_id = p_organization_id
95: and mtl_transactions_enabled_flag = 'Y'
96: and concatenated_segments like p_concatenated_segments;
97: END;

Line 119: from mtl_system_items_kfv

115: restrict_locators_code ,
116: Nvl(shelf_life_code, 1),
117: Nvl(shelf_life_days,0),
118: Nvl(effectivity_control,1)
119: from mtl_system_items_kfv
120: where organization_id = p_Organization_Id
121: and mtl_transactions_enabled_flag = 'Y'
122: and inventory_item_id IN
123: (SELECT inventory_item_id

Line 124: from mtl_system_items

120: where organization_id = p_Organization_Id
121: and mtl_transactions_enabled_flag = 'Y'
122: and inventory_item_id IN
123: (SELECT inventory_item_id
124: from mtl_system_items
125: where organization_id = p_To_Organization_Id
126: and mtl_transactions_enabled_flag = 'Y')
127: and concatenated_segments like p_Concatenated_Segments;
128: ELSE

Line 134: from mtl_system_items_kfv

130: select concatenated_segments,inventory_item_id,description,
131: revision_qty_control_code,lot_control_code,
132: serial_number_control_code,restrict_subinventories_code,restrict_locators_code,
133: location_control_code,Nvl(shelf_life_code, 1),Nvl(shelf_life_days,0), Nvl(effectivity_control,1)
134: from mtl_system_items_kfv
135: where organization_id = p_Organization_Id
136: and mtl_transactions_enabled_flag = 'Y'
137: and concatenated_segments like p_Concatenated_Segments;
138: END IF;

Line 185: from mtl_system_items

181: BEGIN
182: IF p_Transaction_Action_Id = 3 THEN
183: l_org := p_To_Organization_Id;
184: select restrict_locators_code into l_Restrict_Locators_Code
185: from mtl_system_items
186: where inventory_item_id = p_Inventory_Item_Id and organization_id = l_org;
187: ELSE
188: l_org := p_Organization_Id;
189: l_Restrict_Locators_Code := p_Restrict_Locators_Code;

Line 335: from mtl_system_items

331: IF p_Transaction_Action_Id = 3 THEN
332: l_org := p_To_Organization_Id;
333: select restrict_subinventories_code
334: into l_Restrict_Subinventories_Code
335: from mtl_system_items
336: where organization_id = l_org
337: and inventory_item_id = p_Inventory_Item_Id;
338: ELSE
339: l_org := p_Organization_Id;

Line 364: FROM mtl_system_items

360: END IF;
361:
362: SELECT Inventory_Asset_Flag
363: INTO l_Inventory_Asset_Flag
364: FROM mtl_system_items
365: WHERE inventory_item_id = p_Inventory_Item_Id
366: AND organization_id = l_org;
367:
368: FND_PROFILE.GET('INV:EXPENSE_TO_ASSET_TRANSFER',l_expense_to_asset);