View: WSHBV_CONTAINER_ITEMS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_CONTAINER_ITEMS

View Text

SELECT WCI.MASTER_ORGANIZATION_ID
, WCI.CONTAINER_ITEM_ID
, '_KF:INV:MSTK:MSI1'
, '_LA:PREFERRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WCI.LOAD_ITEM_ID
, '_KF:INV:MSTK:MSI2'
, WCI.MAX_LOAD_QUANTITY
, WCI.CREATION_DATE
, WCI.CREATED_BY
, WCI.LAST_UPDATE_DATE
, WCI.LAST_UPDATED_BY
, WCI.LAST_UPDATE_LOGIN
FROM WSH_CONTAINER_ITEMS WCI
, MTL_SYSTEM_ITEMS MSI1
, MTL_SYSTEM_ITEMS MSI2
WHERE WCI.CONTAINER_ITEM_ID = MSI1.INVENTORY_ITEM_ID
AND WCI.MASTER_ORGANIZATION_ID = MSI1.ORGANIZATION_ID
AND WCI.LOAD_ITEM_ID = MSI2.INVENTORY_ITEM_ID
AND WCI.MASTER_ORGANIZATION_ID = MSI2.ORGANIZATION_ID
AND '_SEC:WCI.MASTER_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns