Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the country profiles |
Implementation/DBA Data: | APPS.GR_COUNTRY_PROFILES_V |
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')