APPS.INV_TRANSACTION_LOVS dependencies on MTL_ITEM_SUB_VAL_V

Line 269: FROM mtl_item_sub_val_v

265: IF (p_Transaction_Action_Id <> 2 and p_Transaction_Action_Id <>3) THEN
266: IF p_Restrict_Subinventories_Code = 1 THEN
267: OPEN x_Zones FOR
268: SELECT secondary_inventory_name,description,asset_inventory
269: FROM mtl_item_sub_val_v
270: WHERE organization_id = p_Organization_Id AND
271: inventory_item_id = p_Inventory_Item_Id AND
272: secondary_inventory_name like p_Secondary_Inventory_Name;
273: ELSE

Line 373: FROM MTL_ITEM_SUB_VAL_V

369: IF (nvl(l_expense_to_asset,'2') = '1') THEN
370: IF l_Restrict_Subinventories_Code = 1 THEN
371: OPEN x_to_sub FOR
372: SELECT secondary_inventory_name,description
373: FROM MTL_ITEM_SUB_VAL_V
374: WHERE organization_id = l_org
375: AND inventory_item_id = p_Inventory_Item_Id
376: AND secondary_inventory_name like p_Secondary_Inventory_Name;
377: ELSE

Line 390: FROM MTL_ITEM_SUB_VAL_V

386: IF l_Inventory_Asset_Flag = 'Y' THEN
387: IF l_From_Sub_Asset_Inventory = 1 THEN
388: OPEN x_to_sub FOR
389: SELECT secondary_inventory_name,description
390: FROM MTL_ITEM_SUB_VAL_V
391: WHERE ORGANIZATION_ID = l_org
392: AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
393: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
394: ELSE

Line 405: FROM MTL_ITEM_SUB_VAL_V

401: END IF;
402: ELSE
403: OPEN x_to_sub FOR
404: SELECT secondary_inventory_name,description
405: FROM MTL_ITEM_SUB_VAL_V
406: WHERE ORGANIZATION_ID = l_org
407: AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
408: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
409: END IF;