View: WSHFV_CONTAINER_ITEMS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Items that can be packed into the Container.
Implementation/DBA Data:	APPS.WSHFV_CONTAINER_ITEMS

View Text

SELECT WCI.MASTER_ORGANIZATION_ID
, MPA.ORGANIZATION_CODE
, ORG.NAME
, WCI.CONTAINER_ITEM_ID
, '_KF:INV:MSTK:MSI1'
, '_LA:PREFERRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_CONTAINER_ITEMS:WCI'
, 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
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS MPA
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 WCI.MASTER_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND WCI.MASTER_ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND '_SEC:WCI.MASTER_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns