DBA Data[Home] [Help]

VIEW: APPS.PO_ALL_DOC_STYLE_LINES

Source

View Text - Preformatted

SELECT PDSLT.STYLE_ID , PDSLT.DISPLAY_NAME , PDSLT.LANGUAGE , PDSLT.DOCUMENT_SUBTYPE , PDSH.STATUS , PDSLB.ENABLED_FLAG FROM PO_DOC_STYLE_LINES_TL PDSLT, PO_DOC_STYLE_LINES_B PDSLB, PO_DOC_STYLE_HEADERS PDSH WHERE PDSLB.STYLE_ID = PDSLT.STYLE_ID AND PDSLB.DOCUMENT_SUBTYPE = PDSLT.DOCUMENT_SUBTYPE AND PDSH.STYLE_ID = PDSLT.STYLE_ID
View Text - HTML Formatted

SELECT PDSLT.STYLE_ID
, PDSLT.DISPLAY_NAME
, PDSLT.LANGUAGE
, PDSLT.DOCUMENT_SUBTYPE
, PDSH.STATUS
, PDSLB.ENABLED_FLAG
FROM PO_DOC_STYLE_LINES_TL PDSLT
, PO_DOC_STYLE_LINES_B PDSLB
, PO_DOC_STYLE_HEADERS PDSH
WHERE PDSLB.STYLE_ID = PDSLT.STYLE_ID
AND PDSLB.DOCUMENT_SUBTYPE = PDSLT.DOCUMENT_SUBTYPE
AND PDSH.STYLE_ID = PDSLT.STYLE_ID