VIEW: APPS.GR_COUNTRY_PROFILES_V

Source

View Text - Preformatted

SELECT cp.rowid, cp.territory_code, ft.description, cp.language, fl.description, cp.label_code_exposure, l.label_description, cp.label_code_toxic, l1.label_description, cp.disclosure_code, d.disclosure_description, cp.document_code, dc.document_description, cp.created_by, cp.creation_date, cp.last_updated_by, cp.last_update_date, cp.last_update_login from gr_country_profiles cp, fnd_languages_vl fl, fnd_territories_vl ft, gr_document_codes dc, gr_disclosures d, gr_labels_tl l, gr_labels_tl l1 WHERE cp.language=fl.language_code and cp.territory_code=ft.territory_code and cp.document_code=dc.document_code and cp.disclosure_code=d.disclosure_code and cp.label_code_exposure=l.label_code(+) and l.language(+)=USERENV('LANG') and cp.label_code_toxic=l1.label_code(+)and l1.language(+)=USERENV('LANG')

View Text - HTML Formatted

SELECT CP.ROWID
, CP.TERRITORY_CODE
, FT.DESCRIPTION
, CP.LANGUAGE
, FL.DESCRIPTION
, CP.LABEL_CODE_EXPOSURE
, L.LABEL_DESCRIPTION
, CP.LABEL_CODE_TOXIC
, L1.LABEL_DESCRIPTION
, CP.DISCLOSURE_CODE
, D.DISCLOSURE_DESCRIPTION
, CP.DOCUMENT_CODE
, DC.DOCUMENT_DESCRIPTION
, CP.CREATED_BY
, CP.CREATION_DATE
, CP.LAST_UPDATED_BY
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATE_LOGIN
FROM GR_COUNTRY_PROFILES CP
, FND_LANGUAGES_VL FL
, FND_TERRITORIES_VL FT
, GR_DOCUMENT_CODES DC
, GR_DISCLOSURES D
, GR_LABELS_TL L
, GR_LABELS_TL L1
WHERE CP.LANGUAGE=FL.LANGUAGE_CODE
AND CP.TERRITORY_CODE=FT.TERRITORY_CODE
AND CP.DOCUMENT_CODE=DC.DOCUMENT_CODE
AND CP.DISCLOSURE_CODE=D.DISCLOSURE_CODE
AND CP.LABEL_CODE_EXPOSURE=L.LABEL_CODE(+)
AND L.LANGUAGE(+)=USERENV('LANG')
AND CP.LABEL_CODE_TOXIC=L1.LABEL_CODE(+)AND L1.LANGUAGE(+)=USERENV('LANG')