View: MTL_PHYSICAL_SUBINVENTORIES_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_PHYSICAL_SUBINVENTORIES_V

View Text

SELECT MPI.ORGANIZATION_ID
, MPI.PHYSICAL_INVENTORY_ID
, MSUB.SECONDARY_INVENTORY_NAME SUBINVENTORY
, MSUB.LOCATOR_TYPE
, MSUB.DESCRIPTION
FROM MTL_PHYSICAL_INVENTORIES MPI
, MTL_SECONDARY_INVENTORIES MSUB
WHERE MPI.ORGANIZATION_ID = MSUB.ORGANIZATION_ID
AND ((MPI.ALL_SUBINVENTORIES_FLAG = 1
AND MSUB.QUANTITY_TRACKED = 1) OR (MPI.ALL_SUBINVENTORIES_FLAG = 2
AND EXISTS (SELECT 'X'
FROM MTL_PHYSICAL_SUBINVENTORIES MPS
WHERE MPS.ORGANIZATION_ID = MSUB.ORGANIZATION_ID
AND MPS.SUBINVENTORY = MSUB.SECONDARY_INVENTORY_NAME
AND MPS.PHYSICAL_INVENTORY_ID = MPI.PHYSICAL_INVENTORY_ID)))
AND (MSUB.SUBINVENTORY_TYPE = 1 OR MSUB.SUBINVENTORY_TYPE IS NULL)

Columns