View: MTL_SECONDARY_LOCATORS_ALL_V

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

View Text

SELECT S.ROWID
, S.INVENTORY_ITEM_ID
, S.ORGANIZATION_ID
, S.SECONDARY_LOCATOR
, L.DESCRIPTION
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.PRIMARY_LOCATOR_FLAG
, S.PICKING_ORDER
, S.SUBINVENTORY_CODE
, S.MAXIMUM_QUANTITY
FROM MTL_SECONDARY_LOCATORS S
, MTL_ITEM_LOCATIONS L
WHERE S.SECONDARY_LOCATOR = L.INVENTORY_LOCATION_ID (+)
AND S.ORGANIZATION_ID = L.ORGANIZATION_ID

Columns