[Home] [Help]
View: GR_DOC_HDR_FTR_V
Product: | GR - Process Manufacturing Regulatory Management |
Description: | Document header view |
Implementation/DBA Data: |
APPS.GR_DOC_HDR_FTR_V
|
View Text
SELECT DHF.ROWID ROW_ID
, DHF.DOCUMENT_CODE
, DHF.LINE_TYPE
, DHF.LINE_NO
, DHF.LEFT_LABEL_CODE
, LT1.LABEL_DESCRIPTION
, DHF.RIGHT_LABEL_CODE
, LT2.LABEL_DESCRIPTION
, DHF.CREATED_BY
, DHF.CREATION_DATE
, DHF.LAST_UPDATED_BY
, DHF.LAST_UPDATE_DATE
, DHF.LAST_UPDATE_LOGIN
FROM GR_DOC_HDR_FTR DHF
, GR_LABELS_TL LT1
, GR_LABELS_TL LT2
WHERE DHF.LEFT_LABEL_CODE = LT1.LABEL_CODE (+)
AND LT1.LANGUAGE (+) = USERENV('LANG')
AND DHF.RIGHT_LABEL_CODE = LT2.LABEL_CODE (+)
AND LT2.LANGUAGE (+) = USERENV('LANG')
Columns
Name |
ROW_ID |
DOCUMENT_CODE |
LINE_TYPE |
LINE_NO |
LEFT_LABEL_CODE |
LEFT_LABEL_DESCRIPTION |
RIGHT_LABEL_CODE |
RIGHT_LABEL_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |