VIEW: APPS.JE_IT_EXEMPT_LETTERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'