VIEW: APPS.PO_DOC_STYLE_LINES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.STYLE_ID , B.DOCUMENT_SUBTYPE , B.ENABLED_FLAG , T.DISPLAY_NAME , B.STYLE_ID || '-' || B.DOCUMENT_SUBTYPE STYLE_SUBTYPE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.LAST_UPDATE_DATE From PO_DOC_STYLE_LINES_B B, PO_DOC_STYLE_LINES_TL T WHERE T.LANGUAGE = userenv('LANG') and B.STYLE_ID = T.STYLE_ID and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.STYLE_ID
, B.DOCUMENT_SUBTYPE
, B.ENABLED_FLAG
, T.DISPLAY_NAME
, B.STYLE_ID || '-' || B.DOCUMENT_SUBTYPE STYLE_SUBTYPE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
FROM PO_DOC_STYLE_LINES_B B
, PO_DOC_STYLE_LINES_TL T
WHERE T.LANGUAGE = USERENV('LANG')
AND B.STYLE_ID = T.STYLE_ID
AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE