DBA Data[Home] [Help]

VIEW: APPS.FND_PRINTER_STYLES_VIEW

Source

View Text - Preformatted

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
View Text - HTML Formatted

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