Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows that have a language dependent description for the label class code. |
Implementation/DBA Data: | APPS.GR_LABEL_CLASSES_B_V |
SELECT LC.ROWID ROW_ID
, LC.LABEL_CLASS_CODE
, LC.FORM_BLOCK
, LC.ROLLUP_TYPE
, LC.ROLLUP_PROPERTY
, LP.DESCRIPTION
, LC.ROLLUP_LABEL
, LT.LABEL_DESCRIPTION
, LC.CREATED_BY
, LC.CREATION_DATE
, LC.LAST_UPDATED_BY
, LC.LAST_UPDATE_DATE
, LC.LAST_UPDATE_LOGIN
, LC.ATTRIBUTE_CATEGORY
, LC.ATTRIBUTE1
, LC.ATTRIBUTE2
, LC.ATTRIBUTE3
, LC.ATTRIBUTE4
, LC.ATTRIBUTE5
, LC.ATTRIBUTE6
, LC.ATTRIBUTE7
, LC.ATTRIBUTE8
, LC.ATTRIBUTE9
, LC.ATTRIBUTE10
, LC.ATTRIBUTE11
, LC.ATTRIBUTE12
, LC.ATTRIBUTE13
, LC.ATTRIBUTE14
, LC.ATTRIBUTE15
, LC.ATTRIBUTE16
, LC.ATTRIBUTE17
, LC.ATTRIBUTE18
, LC.ATTRIBUTE19
, LC.ATTRIBUTE20
, LC.ATTRIBUTE21
, LC.ATTRIBUTE22
, LC.ATTRIBUTE23
, LC.ATTRIBUTE24
, LC.ATTRIBUTE25
, LC.ATTRIBUTE26
, LC.ATTRIBUTE27
, LC.ATTRIBUTE28
, LC.ATTRIBUTE29
, LC.ATTRIBUTE30
FROM GR_LABEL_CLASSES_B LC
, GR_LABELS_TL LT
, GR_PROPERTIES_TL LP
WHERE LC.ROLLUP_LABEL = LT.LABEL_CODE (+)
AND LT.LANGUAGE (+) = USERENV('LANG')
AND LC.ROLLUP_PROPERTY = LP.PROPERTY_ID (+)
AND LP.LANGUAGE (+) = USERENV('LANG')