VIEW: APPS.GR_LABELS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.label_code ,b.safety_category_code ,b.label_class_code ,b.data_position_indicator ,b.label_properties_flag ,b.label_value_required ,b.item_properties_flag ,b.ingredient_value_flag ,b.inherit_from_label_code ,b.print_ingredient_indicator ,b.print_font ,b.print_size ,b.ingredient_label_code ,b.value_procedure ,b.attribute_category ,b.attribute1 ,b.attribute2 ,b.attribute3 ,b.attribute4 ,b.attribute5 ,b.attribute6 ,b.attribute7 ,b.attribute8 ,b.attribute9 ,b.attribute10 ,b.attribute11 ,b.attribute12 ,b.attribute13 ,b.attribute14 ,b.attribute15 ,b.attribute16 ,b.attribute17 ,b.attribute18 ,b.attribute19 ,b.attribute20 ,b.attribute21 ,b.attribute22 ,b.attribute23 ,b.attribute24 ,b.attribute25 ,b.attribute26 ,b.attribute27 ,b.attribute28 ,b.attribute29 ,b.attribute30 ,b.created_by ,b.creation_date ,b.last_updated_by ,b.last_update_date ,b.last_update_login ,t.label_description ,b.rollup_disclosure_code FROM gr_labels_tl t ,gr_labels_b b WHERE b.label_code = t.label_code AND t.language = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.LABEL_CODE
, B.SAFETY_CATEGORY_CODE
, B.LABEL_CLASS_CODE
, B.DATA_POSITION_INDICATOR
, B.LABEL_PROPERTIES_FLAG
, B.LABEL_VALUE_REQUIRED
, B.ITEM_PROPERTIES_FLAG
, B.INGREDIENT_VALUE_FLAG
, B.INHERIT_FROM_LABEL_CODE
, B.PRINT_INGREDIENT_INDICATOR
, B.PRINT_FONT
, B.PRINT_SIZE
, B.INGREDIENT_LABEL_CODE
, B.VALUE_PROCEDURE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.ATTRIBUTE21
, B.ATTRIBUTE22
, B.ATTRIBUTE23
, B.ATTRIBUTE24
, B.ATTRIBUTE25
, B.ATTRIBUTE26
, B.ATTRIBUTE27
, B.ATTRIBUTE28
, B.ATTRIBUTE29
, B.ATTRIBUTE30
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.LABEL_DESCRIPTION
, B.ROLLUP_DISCLOSURE_CODE
FROM GR_LABELS_TL T
, GR_LABELS_B B
WHERE B.LABEL_CODE = T.LABEL_CODE
AND T.LANGUAGE = USERENV('LANG')