VIEW: APPS.GR_RECIPIENT_INFO_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)