Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the recipients information table |
Implementation/DBA Data: | APPS.GR_RECIPIENT_INFO_V |
SELECT RI.ROWID ROW_ID
, RI.RECIPIENT_CODE
, RI.RECIPIENT_NAME
, RI.DOCUMENT_CODE
, RI.TERRITORY_CODE
, RI.PRINT_RECIPIENT_PRODUCT_CODE
, RI.UPDATE_ADDRESS_FLAG
, RI.DISCLOSE_ALL_INGREDIENTS_FLAG
, RI.ADDRESS_TO_PRINT
, RI.DOCUMENT_PRINT_FREQUENCY
, RI.DISCLOSURE_CODE
, RI.REGION_CODE
, RI.COVER_LETTER_ID
, RI.ADDITIONAL_DOCUMENTS_FLAG
, RI.ADDITIONAL_ADDRESS_FLAG
, RI.SHIPPING_ADDRESS
, RI.INVOICE_ADDRESS
, RI.ATTRIBUTE_CATEGORY
, RI.ATTRIBUTE1
, RI.ATTRIBUTE2
, RI.ATTRIBUTE3
, RI.ATTRIBUTE4
, RI.ATTRIBUTE5
, RI.ATTRIBUTE6
, RI.ATTRIBUTE8
, RI.ATTRIBUTE7
, RI.ATTRIBUTE9
, RI.ATTRIBUTE10
, RI.ATTRIBUTE11
, RI.ATTRIBUTE12
, RI.ATTRIBUTE13
, RI.ATTRIBUTE14
, RI.ATTRIBUTE15
, RI.ATTRIBUTE16
, RI.ATTRIBUTE17
, RI.ATTRIBUTE18
, RI.ATTRIBUTE19
, RI.ATTRIBUTE20
, RI.ATTRIBUTE21
, RI.ATTRIBUTE22
, RI.ATTRIBUTE23
, RI.ATTRIBUTE24
, RI.ATTRIBUTE25
, RI.ATTRIBUTE26
, RI.ATTRIBUTE27
, RI.ATTRIBUTE28
, RI.ATTRIBUTE29
, RI.ATTRIBUTE30
, RI.CREATED_BY
, RI.CREATION_DATE
, RI.LAST_UPDATED_BY
, RI.LAST_UPDATE_DATE
, RI.LAST_UPDATE_LOGIN
, R.REGION_DESCRIPTION
, D.DISCLOSURE_DESCRIPTION
FROM GR_RECIPIENT_INFO RI
, GR_DISCLOSURES D
, GR_REGIONS R
WHERE RI.REGION_CODE = R.REGION_CODE (+)
AND RI.DISCLOSURE_CODE = D.DISCLOSURE_CODE (+)