VIEW: APPS.JL_AR_AR_DOC_LETTER_V

Source

View Text - Preformatted

SELECT doc.rowid row_id, tax_category_id, org_tax_attribute_name, vlkp1.meaning org_name_desc, org_tax_attribute_value, vlkp2.meaning org_val_desc, con_tax_attribute_name, clkp1.meaning con_name_desc, con_tax_attribute_value, clkp2.meaning con_val_desc, doc.document_letter, dlkp.meaning doc_letter_desc, doc.start_date_active, doc.end_date_active, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ORG_ID FROM jl_ar_ar_doc_letter doc, fnd_lookups vlkp1, fnd_lookups vlkp2, fnd_lookups clkp1, fnd_lookups clkp2, fnd_lookups dlkp WHERE doc.org_tax_attribute_name = vlkp1.lookup_code AND vlkp1.lookup_type = 'ORGANIZATION_ATTRIBUTE' AND doc.org_tax_attribute_value = vlkp2.lookup_code AND vlkp2.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE' AND doc.con_tax_attribute_name = clkp1.lookup_code AND clkp1.lookup_type = 'CONTRIBUTOR_ATTRIBUTE' AND doc.con_tax_attribute_value = clkp2.lookup_code AND clkp2.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE' AND doc.document_letter = dlkp.lookup_code AND dlkp.lookup_type = 'JLAR_DOCUMENT_LETTER'

View Text - HTML Formatted

SELECT DOC.ROWID ROW_ID
, TAX_CATEGORY_ID
, ORG_TAX_ATTRIBUTE_NAME
, VLKP1.MEANING ORG_NAME_DESC
, ORG_TAX_ATTRIBUTE_VALUE
, VLKP2.MEANING ORG_VAL_DESC
, CON_TAX_ATTRIBUTE_NAME
, CLKP1.MEANING CON_NAME_DESC
, CON_TAX_ATTRIBUTE_VALUE
, CLKP2.MEANING CON_VAL_DESC
, DOC.DOCUMENT_LETTER
, DLKP.MEANING DOC_LETTER_DESC
, DOC.START_DATE_ACTIVE
, DOC.END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM JL_AR_AR_DOC_LETTER DOC
, FND_LOOKUPS VLKP1
, FND_LOOKUPS VLKP2
, FND_LOOKUPS CLKP1
, FND_LOOKUPS CLKP2
, FND_LOOKUPS DLKP
WHERE DOC.ORG_TAX_ATTRIBUTE_NAME = VLKP1.LOOKUP_CODE
AND VLKP1.LOOKUP_TYPE = 'ORGANIZATION_ATTRIBUTE'
AND DOC.ORG_TAX_ATTRIBUTE_VALUE = VLKP2.LOOKUP_CODE
AND VLKP2.LOOKUP_TYPE = 'JLZZ_AR_TX_ATTR_VALUE'
AND DOC.CON_TAX_ATTRIBUTE_NAME = CLKP1.LOOKUP_CODE
AND CLKP1.LOOKUP_TYPE = 'CONTRIBUTOR_ATTRIBUTE'
AND DOC.CON_TAX_ATTRIBUTE_VALUE = CLKP2.LOOKUP_CODE
AND CLKP2.LOOKUP_TYPE = 'JLZZ_AR_TX_ATTR_VALUE'
AND DOC.DOCUMENT_LETTER = DLKP.LOOKUP_CODE
AND DLKP.LOOKUP_TYPE = 'JLAR_DOCUMENT_LETTER'