[Home] [Help]
View: GR_PHRASE_GROUPS_V
Product: | GR - Process Manufacturing Regulatory Management |
Description: | Contains the rows for the phrase group code |
Implementation/DBA Data: |
APPS.GR_PHRASE_GROUPS_V
|
View Text
SELECT PGA.ROWID ROW_ID
, PGA.PHRASE_GROUP_CODE
, PGC.PHRASE_GROUP_DESCRIPTION
, PGA.PHRASE_CODE
, PT.PHRASE_TEXT
, PGA.SEQUENCE_NUMBER
, PGA.CREATED_BY
, PGA.CREATION_DATE
, PGA.LAST_UPDATED_BY
, PGA.LAST_UPDATE_DATE
, PGA.LAST_UPDATE_LOGIN
FROM GR_PHRASES_TL PT
, GR_PHRASES_B PB
, GR_PHRASE_GROUP_CODES PGC
, GR_PHRASE_GROUP_ASSOC PGA
WHERE PGA.PHRASE_GROUP_CODE = PGC.PHRASE_GROUP_CODE
AND PGA.PHRASE_CODE = PB.PHRASE_CODE
AND PB.PHRASE_CODE = PT.PHRASE_CODE
AND PT.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PHRASE_GROUP_CODE |
PHRASE_GROUP_DESCRIPTION |
PHRASE_CODE |
PHRASE_TEXT |
SEQUENCE_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |