VIEW: APPS.GR_PHRASES_B_V

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.phrase_code ,b.main_heading_code ,m.main_heading_description ,b.sub_heading_code ,s.sub_heading_desc ,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 FROM gr_phrases_b b ,gr_main_headings_tl m ,gr_sub_headings_tl s WHERE b.main_heading_code = m.main_heading_code AND b.sub_heading_code = s.sub_heading_code (+) AND m.language = USERENV('LANG') AND s.language (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PHRASE_CODE
, B.MAIN_HEADING_CODE
, M.MAIN_HEADING_DESCRIPTION
, B.SUB_HEADING_CODE
, S.SUB_HEADING_DESC
, 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
FROM GR_PHRASES_B B
, GR_MAIN_HEADINGS_TL M
, GR_SUB_HEADINGS_TL S
WHERE B.MAIN_HEADING_CODE = M.MAIN_HEADING_CODE
AND B.SUB_HEADING_CODE = S.SUB_HEADING_CODE (+)
AND M.LANGUAGE = USERENV('LANG')
AND S.LANGUAGE (+) = USERENV('LANG')