VIEW: APPS.WSHFV_CONTAINERS

Source

View Text - Preformatted

SELECT WDD.DELIVERY_DETAIL_ID CONTAINER_ID, WDA.DELIVERY_ID , WND.NAME DELIVERY_NAME, WDD.REQUESTED_QUANTITY PACKED_QUANTITY , WDD.VOLUME , WDD.VOLUME_UOM_CODE , WDD.NET_WEIGHT, WDD.FILL_PERCENT, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_CONTAINER_ID, PDD.CONTAINER_NAME PARENT_CONTAINER_NAME, WDD.GROSS_WEIGHT , WDD.WEIGHT_UOM_CODE , WDD.ORGANIZATION_ID , MP.ORGANIZATION_CODE, HAOU.NAME ORGANIZATION_NAME, MSI.DESCRIPTION CONTAINER_DESCRIPTION , WDD.CONTAINER_NAME, WDD.CONTAINER_TYPE_CODE, WDD.SUBINVENTORY , WDD.REVISION , WDD.LOT_NUMBER , WDD.SERIAL_NUMBER , WDD.MASTER_SERIAL_NUMBER , WDD.CREATION_DATE , WDD.CREATED_BY , WDD.LAST_UPDATE_DATE , WDD.LAST_UPDATED_BY, WDD.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', SUBINV.DESCRIPTION SUBINVENTORY_DESCRIPTION, WDD.LOCATOR_ID, '_KF:INV:MTLL:MIL' FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, MTL_SYSTEM_ITEMS MSI, WSH_NEW_DELIVERIES WND, WSH_DELIVERY_DETAILS PDD, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS HAOU, MTL_SECONDARY_INVENTORIES SUBINV, MTL_ITEM_LOCATIONS MIL WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) AND WDD.ORGANIZATION_ID =MP.ORGANIZATION_ID(+) AND WDD.ORGANIZATION_ID =HAOU.ORGANIZATION_ID(+) AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID AND PDD.DELIVERY_DETAIL_ID(+)=WDA.PARENT_DELIVERY_DETAIL_ID AND WDA.DELIVERY_ID=WND.DELIVERY_ID (+) AND WDD.SUBINVENTORY = SUBINV.SECONDARY_INVENTORY_NAME(+) AND WDD.ORGANIZATION_ID = SUBINV.ORGANIZATION_ID(+) AND WDD.CONTAINER_FLAG='Y' AND NVL(WDD.LINE_DIRECTION, 'O') IN ('O', 'IO') --AND WDD.SOURCE_CODE='WSH' AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+) AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+) AND '_SEC:WDD.ORGANIZATION_ID' is not null with read only

View Text - HTML Formatted

SELECT WDD.DELIVERY_DETAIL_ID CONTAINER_ID
, WDA.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WDD.REQUESTED_QUANTITY PACKED_QUANTITY
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, WDD.NET_WEIGHT
, WDD.FILL_PERCENT
, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_CONTAINER_ID
, PDD.CONTAINER_NAME PARENT_CONTAINER_NAME
, WDD.GROSS_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HAOU.NAME ORGANIZATION_NAME
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, WDD.SUBINVENTORY
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.SERIAL_NUMBER
, WDD.MASTER_SERIAL_NUMBER
, WDD.CREATION_DATE
, WDD.CREATED_BY
, WDD.LAST_UPDATE_DATE
, WDD.LAST_UPDATED_BY
, WDD.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, SUBINV.DESCRIPTION SUBINVENTORY_DESCRIPTION
, WDD.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS WDA
, MTL_SYSTEM_ITEMS MSI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_DETAILS PDD
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_SECONDARY_INVENTORIES SUBINV
, MTL_ITEM_LOCATIONS MIL
WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WDD.ORGANIZATION_ID =MP.ORGANIZATION_ID(+)
AND WDD.ORGANIZATION_ID =HAOU.ORGANIZATION_ID(+)
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND PDD.DELIVERY_DETAIL_ID(+)=WDA.PARENT_DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID (+)
AND WDD.SUBINVENTORY = SUBINV.SECONDARY_INVENTORY_NAME(+)
AND WDD.ORGANIZATION_ID = SUBINV.ORGANIZATION_ID(+)
AND WDD.CONTAINER_FLAG='Y'
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') --AND WDD.SOURCE_CODE='WSH'
AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+)
AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+)
AND '_SEC:WDD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY