VIEW: APPS.JE_IT_VAT_REG_DOCS_V

Source

View Text - Preformatted

SELECT vrd.vat_register_id vat_register_id, vrd.document document, vrd.creation_date creation_date, vrd.created_by created_by, vrd.last_updated_by last_updated_by, vrd.last_update_date last_update_date, ds.name document_dsp, vrd.last_update_login last_update_login from je_it_vat_reg_docs vrd, fnd_document_sequences ds where vrd.document = ds.doc_sequence_id

View Text - HTML Formatted

SELECT VRD.VAT_REGISTER_ID VAT_REGISTER_ID
, VRD.DOCUMENT DOCUMENT
, VRD.CREATION_DATE CREATION_DATE
, VRD.CREATED_BY CREATED_BY
, VRD.LAST_UPDATED_BY LAST_UPDATED_BY
, VRD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DS.NAME DOCUMENT_DSP
, VRD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JE_IT_VAT_REG_DOCS VRD
, FND_DOCUMENT_SEQUENCES DS
WHERE VRD.DOCUMENT = DS.DOC_SEQUENCE_ID