View: FND_PRINTER_STYLES_VIEW

Product:	FND - Application Object Library
Description:	View required by Define Concurrent Programs form for Oracle7 to avoid an outer join
Implementation/DBA Data:	APPS.FND_PRINTER_STYLES_VIEW

View Text

SELECT S.PRINTER_STYLE_NAME
, ST.USER_PRINTER_STYLE_NAME
, S.WIDTH
, S.LENGTH
, P.PRINTER_NAME
FROM FND_PRINTER P
, FND_PRINTER_INFORMATION I
, FND_PRINTER_STYLES S
, FND_PRINTER_STYLES_TL ST
WHERE P.PRINTER_TYPE (+) = I.PRINTER_TYPE
AND I.PRINTER_STYLE (+) = ST.PRINTER_STYLE_NAME
AND S.PRINTER_STYLE_NAME=ST.PRINTER_STYLE_NAME

Columns