View: JE_IT_EXEMPT_LETTERS_V

Product:	JE - European Localizations
Description:	Defined to display exemption letter type and Italian legislation clause on Italian Exemption Letter form.
Implementation/DBA Data:	APPS.JE_IT_EXEMPT_LETTERS_V

View Text

SELECT EL.ROWID ROW_ID
, EL.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, EL.VENDOR_ID VENDOR_ID
, EL.EFFECTIVE_FROM EFFECTIVE_FROM
, EL.EFFECTIVE_TO EFFECTIVE_TO
, EL.YEAR YEAR
, EL.EXEMPTION_LETTER_ID EXEMPTION_LETTER_ID
, EL.CREATION_DATE CREATION_DATE
, EL.CREATED_BY CREATED_BY
, EL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EL.LAST_UPDATED_BY LAST_UPDATED_BY
, EL.CLAUSE_REF CLAUSE_REF
, EL.PRINT_FLAG PRINT_FLAG
, EL.CUSTOM_FLAG CUSTOM_FLAG
, EL.ISSUE_FLAG ISSUE_FLAG
, EL.ISSUE_DATE ISSUE_DATE
, LU1.MEANING CLAUSE_REF_DSP
, EL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EL.SET_OF_BOOKS_ID
, EL.LETTER_TYPE
, LU2.MEANING LETTER_TYPE_DSP
, EL.LIMIT_AMOUNT
FROM JE_IT_EXEMPT_LETTERS EL
, FND_LOOKUPS LU1
, FND_LOOKUPS LU2
WHERE EL.CLAUSE_REF=LU1.LOOKUP_CODE
AND LU2.LOOKUP_CODE = EL.LETTER_TYPE
AND LU1.LOOKUP_TYPE='JEIT_CLAUSE_REF'
AND LU2.LOOKUP_TYPE='JEIT_EXEMPT_LETTER'

Columns