APPS.INV_TRANSACTION_LOVS dependencies on MTL_SECONDARY_INVENTORIES

Line 206: FROM mtl_secondary_inventories

202: p_subinventory_code IN VARCHAR2) IS
203: BEGIN
204: open x_Zones for
205: SELECT secondary_inventory_name, description, locator_type, asset_inventory
206: FROM mtl_secondary_inventories
207: WHERE organization_id = p_organization_id
208: AND secondary_inventory_name like p_subinventory_code;
209: END GET_VALID_SUBS;
210:

Line 216: FROM mtl_secondary_inventories

212: p_organization_id IN NUMBER) IS
213: BEGIN
214: open x_Zones for
215: SELECT secondary_inventory_name,description,asset_inventory
216: FROM mtl_secondary_inventories
217: WHERE organization_id = p_Organization_Id;
218: END GET_FROM_SUBS;
219:
220: PROCEDURE GET_FROM_SUBS(x_Zones OUT NOCOPY /* file.sql.39 change */ t_genref,

Line 307: FROM mtl_secondary_inventories

303: p_secondary_inventory_name IN VARCHAR2) IS
304: BEGIN
305: open x_Zones for
306: sELECT secondary_inventory_name,description,asset_inventory
307: FROM mtl_secondary_inventories
308: WHERE organization_id = p_Organization_Id
309: AND secondary_inventory_name <> p_secondary_inventory_name;
310: END GET_TO_SUB;
311:

Line 355: --from mtl_secondary_inventories

351: --and inventory_item_id = p_Inventory_Item_Id;
352:
353: --select asset_inventory
354: --into l_From_Sub_Asset_Inventory
355: --from mtl_secondary_inventories
356: --where organization_id = l_org
357: --and secondary_inventory_name = l_From_Sub;
358: ELSE
359: l_From_Sub_Asset_Inventory := p_From_Sub_Asset_Inventory;