[Home] [Help]
View: OKC_REPORT_XSL_V
| Product: | OKC - Contracts Core |
| Description: | Used in Contract Printing. Keeps stylesheet for sql-xml-xsl-html contract printing. |
| Implementation/DBA Data: |
APPS.OKC_REPORT_XSL_V
|
View Text
SELECT B.ID
, B.AUTHORING_ORG_ID
, TL.NAME
, TL.XSL_TEXT
, TL.HELP_TEXT
, TL.PROTECTED_YN
, B.START_DATE
, B.END_DATE
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM OKC_REPORT_XSL_B B
, OKC_REPORT_XSL_TL TL
WHERE B.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.AUTHORING_ORG_ID = 0 OR B.AUTHORING_ORG_ID = OKC_CONTEXT.GET_OKC_ORG_ID)
Columns
| Name |
| ID |
| AUTHORING_ORG_ID |
| NAME |
| XSL_TEXT |
| HELP_TEXT |
| PROTECTED_YN |
| START_DATE |
| END_DATE |
| OBJECT_VERSION_NUMBER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |