VIEW: APPS.WSH_REPORT_PRINTERS_V

Source

View Text - Preformatted

SELECT WRP.APPLICATION_ID , WRP.CONCURRENT_PROGRAM_ID, WRP.LEVEL_TYPE_ID , WRP.LEVEL_VALUE_ID, WRP.PRINTER_NAME, WRP.DESCRIPTION, WRP.ENABLED_FLAG, WRP.ATTRIBUTE_CATEGORY, WRP.ATTRIBUTE1, WRP.ATTRIBUTE2, WRp.ATTRIBUTE3, WRP.ATTRIBUTE4, WRP.ATTRIBUTE5, WRP.ATTRIBUTE6, WRP.ATTRIBUTE7, WRP.ATTRIBUTE8, WRP.ATTRIBUTE9, WRP.ATTRIBUTE10, WRP.ATTRIBUTE11, WRP.ATTRIBUTE12, WRP.ATTRIBUTE13, WRP.ATTRIBUTE14, WRP.ATTRIBUTE15, WRP.CREATION_DATE, WRP.CREATED_BY, WRP.LAST_UPDATE_DATE, WRP.LAST_UPDATED_BY, WRP.LAST_UPDATE_LOGIN, WRP.REQUEST_ID, WRP.PROGRAM_APPLICATION_ID, WRP.PROGRAM_ID, WRP.PROGRAM_UPDATE_DATE, WRP.LABEL_ID, WRP.FORMAT_TYPE, WRP.EQUIPMENT_INSTANCE, WRP.ORGANIZATION_ID, WRP.SUBINVENTORY, WRP.DEFAULT_PRINTER_FLAG FROM WSH_REPORT_PRINTERS WRP, FND_PRINTER FPR WHERE WRP.PRINTER_NAME = FPR.PRINTER_NAME

View Text - HTML Formatted

SELECT WRP.APPLICATION_ID
, WRP.CONCURRENT_PROGRAM_ID
, WRP.LEVEL_TYPE_ID
, WRP.LEVEL_VALUE_ID
, WRP.PRINTER_NAME
, WRP.DESCRIPTION
, WRP.ENABLED_FLAG
, WRP.ATTRIBUTE_CATEGORY
, WRP.ATTRIBUTE1
, WRP.ATTRIBUTE2
, WRP.ATTRIBUTE3
, WRP.ATTRIBUTE4
, WRP.ATTRIBUTE5
, WRP.ATTRIBUTE6
, WRP.ATTRIBUTE7
, WRP.ATTRIBUTE8
, WRP.ATTRIBUTE9
, WRP.ATTRIBUTE10
, WRP.ATTRIBUTE11
, WRP.ATTRIBUTE12
, WRP.ATTRIBUTE13
, WRP.ATTRIBUTE14
, WRP.ATTRIBUTE15
, WRP.CREATION_DATE
, WRP.CREATED_BY
, WRP.LAST_UPDATE_DATE
, WRP.LAST_UPDATED_BY
, WRP.LAST_UPDATE_LOGIN
, WRP.REQUEST_ID
, WRP.PROGRAM_APPLICATION_ID
, WRP.PROGRAM_ID
, WRP.PROGRAM_UPDATE_DATE
, WRP.LABEL_ID
, WRP.FORMAT_TYPE
, WRP.EQUIPMENT_INSTANCE
, WRP.ORGANIZATION_ID
, WRP.SUBINVENTORY
, WRP.DEFAULT_PRINTER_FLAG
FROM WSH_REPORT_PRINTERS WRP
, FND_PRINTER FPR
WHERE WRP.PRINTER_NAME = FPR.PRINTER_NAME