VIEW: APPS.WMS_LICENSE_PLATE_NUMBERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)