VIEW: APPS.GR_DOC_HDR_FTR_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')