VIEW: APPS.WSH_PACKED_CONTAINERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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