PO_DOC_STYLE_LINES

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
ROW_ID STYLE_ID DOCUMENT_SUBTYPE ENABLED_FLAG DISPLAY_NAME STYLE_SUBTYPE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE

Name

ROW_ID

STYLE_ID

DOCUMENT_SUBTYPE

ENABLED_FLAG

DISPLAY_NAME

STYLE_SUBTYPE

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

Query

SQL_Statement
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

SQL_Statement

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