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