View: WMS_LPN_CONTENTS_SERIAL_V

Product:	WMS - Warehouse Management
Description:	View of container contents ( only serial controlled items)
Implementation/DBA Data:	APPS.WMS_LPN_CONTENTS_SERIAL_V

View Text

SELECT WLC.LPN_ID
, WLP.LICENSE_PLATE_NUMBER PARENT_LICENSE_PLATE_NUMBER
, WLP.OUTERMOST_LPN_ID
, WLP1.LICENSE_PLATE_NUMBER /* OUTERMOST LPN */
, WLC.INVENTORY_ITEM_ID
, MSI.PADDED_CONCATENATED_SEGMENTS INVENTORY_ITEM
, MSI.DESCRIPTION ITEM_DESCRIPTION
, WLC.REVISION
, WLC.LOT_NUMBER
, WLC.SERIAL_NUMBER
, MSI.PRIMARY_UOM_CODE
, WLC.CURRENT_STATUS
, WLP.ORGANIZATION_ID CURRENT_ORGANIZATION_ID
, WLP.LOCATOR_ID CURRENT_LOCATOR_ID
, WLC.COST_GROUP_ID
, WLP.SUBINVENTORY_CODE CURRENT_SUBINVENTORY_CODE
, MSI.LOT_CONTROL_CODE ITEM_LOT_CONTROL
, MSI.LOCATION_CONTROL_CODE ITEM_LOCATOR_CONTROL
FROM MTL_SERIAL_NUMBERS WLC
, MTL_SYSTEM_ITEMS_KFV MSI
, WMS_LICENSE_PLATE_NUMBERS WLP
, WMS_LICENSE_PLATE_NUMBERS WLP1
WHERE WLC.CURRENT_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND WLC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND WLC.LPN_ID = WLP.LPN_ID
AND WLP.OUTERMOST_LPN_ID = WLP1.LPN_ID

Columns