View: WMS_LICENSE_PLATE_NUMBERS_V

Product:	WMS - Warehouse Management
Description:	Detailed view of WMS_LICENSE_PLATE_NUMBERS, including detailed information on relations between lpns
Implementation/DBA Data:	APPS.WMS_LICENSE_PLATE_NUMBERS_V

View Text

SELECT WLN.ROWID ROW_ID
, WLN.LPN_ID
, WLN.LICENSE_PLATE_NUMBER
, WLN.INVENTORY_ITEM_ID
, WLN.LAST_UPDATE_DATE
, WLN.LAST_UPDATED_BY
, WLN.CREATION_DATE
, WLN.CREATED_BY
, WLN.LAST_UPDATE_LOGIN
, WLN.REQUEST_ID
, WLN.PROGRAM_APPLICATION_ID
, WLN.PROGRAM_ID
, WLN.PROGRAM_UPDATE_DATE
, WLN.REVISION
, WLN.LOT_NUMBER
, WLN.SERIAL_NUMBER
, WLN.ORGANIZATION_ID
, WLN.SUBINVENTORY_CODE
, WLN.LOCATOR_ID
, WLN.COST_GROUP_ID
, CG.COST_GROUP COST_GROUP_NAME
, WLN.PARENT_LPN_ID
, '' PARENT_LICENSE_PLATE_NUMBER
, WLN.LPN_ID OUTERMOST_LPN_ID
, WLN.LICENSE_PLATE_NUMBER OUTERMOST_LICENSE_PLATE_NUMBER
, WLN.GROSS_WEIGHT_UOM_CODE
, WLN.GROSS_WEIGHT
, WLN.CONTENT_VOLUME_UOM_CODE
, WLN.CONTENT_VOLUME
, WLN.TARE_WEIGHT_UOM_CODE
, WLN.TARE_WEIGHT
, WLN.STATUS_ID
, WLN.LPN_CONTEXT
, WLN.SEALED_STATUS
, WLN.LPN_REUSABILITY
, WLN.HOMOGENEOUS_CONTAINER
, WLN.ATTRIBUTE_CATEGORY
, WLN.ATTRIBUTE1
, WLN.ATTRIBUTE2
, WLN.ATTRIBUTE3
, WLN.ATTRIBUTE4
, WLN.ATTRIBUTE5
, WLN.ATTRIBUTE6
, WLN.ATTRIBUTE7
, WLN.ATTRIBUTE8
, WLN.ATTRIBUTE9
, WLN.ATTRIBUTE10
, WLN.ATTRIBUTE11
, WLN.ATTRIBUTE12
, WLN.ATTRIBUTE13
, WLN.ATTRIBUTE14
, WLN.ATTRIBUTE15
, WLN.SOURCE_TYPE_ID
, WLN.SOURCE_HEADER_ID
, WLN.SOURCE_LINE_ID
, WLN.SOURCE_LINE_DETAIL_ID
, WLN.SOURCE_NAME
FROM WMS_LICENSE_PLATE_NUMBERS WLN
, CST_COST_GROUPS CG
WHERE WLN.PARENT_LPN_ID IS NULL
AND WLN.COST_GROUP_ID = CG.COST_GROUP_ID(+) UNION ALL SELECT WLP.ROWID ROW_ID
, WLP.LPN_ID
, WLP.LICENSE_PLATE_NUMBER
, WLP.INVENTORY_ITEM_ID
, WLP.LAST_UPDATE_DATE
, WLP.LAST_UPDATED_BY
, WLP.CREATION_DATE
, WLP.CREATED_BY
, WLP.LAST_UPDATE_LOGIN
, WLP.REQUEST_ID
, WLP.PROGRAM_APPLICATION_ID
, WLP.PROGRAM_ID
, WLP.PROGRAM_UPDATE_DATE
, WLP.REVISION
, WLP.LOT_NUMBER
, WLP.SERIAL_NUMBER
, WLP.ORGANIZATION_ID
, WLP.SUBINVENTORY_CODE
, WLP.LOCATOR_ID
, WLP.COST_GROUP_ID
, CG.COST_GROUP COST_GROUP_NAME
, WLP.PARENT_LPN_ID
, WLP1.LICENSE_PLATE_NUMBER PARENT_LICENSE_PLATE_NUMBER
, WLP.OUTERMOST_LPN_ID
, WLP2.LICENSE_PLATE_NUMBER OUTERMOST_LICENSE_PLATE_NUMBER
, WLP.GROSS_WEIGHT_UOM_CODE
, WLP.GROSS_WEIGHT
, WLP.CONTENT_VOLUME_UOM_CODE
, WLP.CONTENT_VOLUME
, WLP.TARE_WEIGHT_UOM_CODE
, WLP.TARE_WEIGHT
, WLP.STATUS_ID
, WLP.LPN_CONTEXT
, WLP.SEALED_STATUS
, WLP.LPN_REUSABILITY
, WLP.HOMOGENEOUS_CONTAINER
, WLP.ATTRIBUTE_CATEGORY
, WLP.ATTRIBUTE1
, WLP.ATTRIBUTE2
, WLP.ATTRIBUTE3
, WLP.ATTRIBUTE4
, WLP.ATTRIBUTE5
, WLP.ATTRIBUTE6
, WLP.ATTRIBUTE7
, WLP.ATTRIBUTE8
, WLP.ATTRIBUTE9
, WLP.ATTRIBUTE10
, WLP.ATTRIBUTE11
, WLP.ATTRIBUTE12
, WLP.ATTRIBUTE13
, WLP.ATTRIBUTE14
, WLP.ATTRIBUTE15
, WLP.SOURCE_TYPE_ID
, WLP.SOURCE_HEADER_ID
, WLP.SOURCE_LINE_ID
, WLP.SOURCE_LINE_DETAIL_ID
, WLP.SOURCE_NAME
FROM WMS_LICENSE_PLATE_NUMBERS WLP
, WMS_LICENSE_PLATE_NUMBERS WLP1
, WMS_LICENSE_PLATE_NUMBERS WLP2
, CST_COST_GROUPS CG
WHERE WLP.PARENT_LPN_ID = WLP1.LPN_ID
AND WLP.OUTERMOST_LPN_ID = WLP2.LPN_ID
AND WLP.COST_GROUP_ID = CG.COST_GROUP_ID(+)

Columns