Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_PACKED_CONTAINERS_V |
SELECT PC.ROWID
, PC.CONTAINER_ID
, PC.DELIVERY_ID
, PC.CONTAINER_INVENTORY_ITEM_ID
, PC.QUANTITY
, PC.SEQUENCE_NUMBER
, PC.PARENT_SEQUENCE_NUMBER
, PC.GROSS_WEIGHT
, PC.WEIGHT_UOM_CODE
, PC.VOLUME
, PC.VOLUME_UOM_CODE
, PC.NET_WEIGHT
, PC.GROSS_WEIGHT - PC.NET_WEIGHT
, PC.FILL_PERCENT
, PC.PARENT_CONTAINER_ID
, PC.MASTER_CONTAINER_ID
, PC.ORGANIZATION_ID
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MSI.MINIMUM_FILL_PERCENT
, MSI.INTERNAL_VOLUME
, MSI.MAXIMUM_LOAD_WEIGHT
, PC.INVENTORY_LOCATION_ID
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N')
, PC.SUBINVENTORY
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N')
, PC.REVISION
, DECODE(MSI.LOT_CONTROL_CODE
, 2
, 'Y'
, 'N')
, PC.LOT_NUMBER
, DECODE(MSI.SERIAL_NUMBER_CONTROL_CODE
, 2
, 'Y'
, 5
, 'Y'
, 6
, 'Y'
, 'N')
, 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
, PC.RA_INTERFACE_STATUS
, PC.ATTRIBUTE_CATEGORY
, PC.ATTRIBUTE1
, PC.ATTRIBUTE2
, PC.ATTRIBUTE3
, PC.ATTRIBUTE4
, PC.ATTRIBUTE5
, PC.ATTRIBUTE6
, PC.ATTRIBUTE7
, PC.ATTRIBUTE8
, PC.ATTRIBUTE9
, PC.ATTRIBUTE10
, PC.ATTRIBUTE11
, PC.ATTRIBUTE12
, PC.ATTRIBUTE13
, PC.ATTRIBUTE14
, PC.ATTRIBUTE15
, 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 MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS ORG
, WSH_PACKED_CONTAINERS PC
WHERE PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID