Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_AR_AR_DOC_LETTER_V |
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'