DBA Data[Home] [Help]

APPS.INV_TRANSACTION_LOVS dependencies on MTL_SUBINVENTORIES_VAL_V

Line 380: FROM MTL_SUBINVENTORIES_VAL_V

376: AND secondary_inventory_name like p_Secondary_Inventory_Name;
377: ELSE
378: OPEN x_to_sub FOR
379: SELECT secondary_inventory_name,description
380: FROM MTL_SUBINVENTORIES_VAL_V
381: WHERE ORGANIZATION_ID = l_org
382: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
383: END IF;
384: ELSE

Line 415: FROM MTL_SUBINVENTORIES_VAL_V

411: IF l_Inventory_Asset_Flag = 'Y' THEN
412: IF l_From_Sub_Asset_Inventory = 1 THEN
413: OPEN x_to_sub FOR
414: SELECT secondary_inventory_name,description
415: FROM MTL_SUBINVENTORIES_VAL_V
416: WHERE ORGANIZATION_ID = l_org
417: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
418: ELSE
419: OPEN x_to_sub FOR

Line 428: FROM MTL_SUBINVENTORIES_VAL_V

424: END IF;
425: ELSE
426: OPEN x_to_sub FOR
427: SELECT secondary_inventory_name,description
428: FROM MTL_SUBINVENTORIES_VAL_V
429: WHERE ORGANIZATION_ID = l_org
430: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
431: END IF;
432: END IF;