VIEW: APPS.WSHFV_CONTAINER_ITEMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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