1. Tables and Views for SCM
  2. CMR_XLA_FISCAL_DOC_V

CMR_XLA_FISCAL_DOC_V

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: VIEW

Columns

Name

FISCAL_DOCUMENT_NUMBER

FISCAL_DOC_ACCESS_KEY_NUMBER

FISCAL_DOCUMENT_DETAIL_ID

FD_ISSUE_DATE

FD_SERIES

FD_ISSUER_PARTY_NAME

Query

SQL_Statement

select distinct fdh.DOCUMENT_NUMBER FISCAL_DOCUMENT_NUMBER,

fdh.ACCESS_KEY_NUMBER FISCAL_DOC_ACCESS_KEY_NUMBER,

cmrfd.FISCAL_DOCUMENT_DETAIL_ID FISCAL_DOCUMENT_DETAIL_ID,

fdh.ISSUE_DATE FD_ISSUE_DATE,

fdh.SERIES FD_SERIES,

fdliv.ISSUER_PARTY_NAME FD_ISSUER_PARTY_NAME

from cmf_fiscal_doc_headers fdh,

CMF_FISCAL_DOC_LOC_INFO_V fdliv,

cmr_rcv_events CRE,

cmr_fiscal_document_details cmrfd

where fdh.DOCUMENT_HEADER_ID = fdliv.DOCUMENT_HEADER_ID

and CRE.FISCAL_DOCUMENT_DETAIL_ID = cmrfd.FISCAL_DOCUMENT_DETAIL_ID

and cmrfd.FD_HEADER_ID = fdh.DOCUMENT_HEADER_ID