[Home] [Help]
View: GR_LABEL_PROPERTIES_V
Product: | GR - Process Manufacturing Regulatory Management |
Description: | Label properties view |
Implementation/DBA Data: |
APPS.GR_LABEL_PROPERTIES_V
|
View Text
SELECT LP.ROWID ROW_ID
, LP.SEQUENCE_NUMBER
, LP.PROPERTY_ID
, LP.LABEL_CODE
, LP.CREATED_BY
, LP.CREATION_DATE
, LP.LAST_UPDATED_BY
, LP.LAST_UPDATE_DATE
, LP.LAST_UPDATE_LOGIN
, LT.LABEL_DESCRIPTION
, PT.DESCRIPTION
, LP.PROPERTY_REQUIRED
FROM GR_LABELS_TL LT
, GR_LABEL_PROPERTIES LP
, GR_PROPERTIES_TL PT
WHERE LP.PROPERTY_ID = PT.PROPERTY_ID
AND LP.LABEL_CODE = LT.LABEL_CODE
AND LT.LANGUAGE = PT.LANGUAGE
AND PT.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
SEQUENCE_NUMBER |
PROPERTY_ID |
LABEL_CODE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
LABEL_DESCRIPTION |
PROPERTY_DESCRIPTION |
PROPERTY_REQUIRED |