View: WSHFV_PACKED_CONTAINER

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.WSHFV_PACKED_CONTAINER

View Text

SELECT PC.CONTAINER_ID
, PC.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, PC.CONTAINER_INVENTORY_ITEM_ID
, PC.QUANTITY PACKED_QUANTITY
, PC.SEQUENCE_NUMBER
, PC.PARENT_SEQUENCE_NUMBER
, PC.GROSS_WEIGHT
, PC.WEIGHT_UOM_CODE
, PC.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, PC.INVENTORY_LOCATION_ID
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') SUBINV_RESTRICTED_FLAG
, PC.SUBINVENTORY
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N') REVISION_CONTROL_FLAG
, PC.REVISION
, DECODE(MSI.LOT_CONTROL_CODE
, 2
, 'Y'
, 'N') LOT_CONTROL_FLAG
, PC.LOT_NUMBER
, DECODE(MSI.SERIAL_NUMBER_CONTROL_CODE
, 2
, 'Y'
, 5
, 'Y'
, 6
, 'Y'
, 'N') SERIAL_NUMBER_CONTROL_FLAG
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.RESTRICT_LOCATORS_CODE
, MSI.LOCATION_CONTROL_CODE
, ORG.STOCK_LOCATOR_CONTROL_CODE
, ORG.NEGATIVE_INV_RECEIPT_CODE
, PC.SERIAL_NUMBER
, PC.MASTER_SERIAL_NUMBER
, PC.INVENTORY_STATUS INVENTORY_INTERFACED_STATUS
, PC.RA_INTERFACE_STATUS RECEIVABLE_INTERFACED_STATUS
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.LAST_UPDATE_LOGIN
, PC.PROGRAM_APPLICATION_ID
, PC.PROGRAM_ID
, PC.PROGRAM_UPDATE_DATE
, PC.REQUEST_ID
FROM WSH_PACKED_CONTAINERS PC
, MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS ORG
, WSH_DELIVERIES WDL
WHERE PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID
AND WDL.DELIVERY_ID (+) = PC.DELIVERY_ID

Columns