VIEW: APPS.GR_PHRASE_GROUPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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