CMF_RCV_ELIGIBLE_FD_V

Details

• Schema: FUSION

• Object owner: CMF

• Object type: VIEW

Columns

Name
DOCUMENT_HEADER_ID DOCUMENT_NUMBER ACCESS_KEY_NUMBER SOURCE_DOCUMENT_TYPE DOCUMENT_TYPE ISSUER_TAX_ID RECEIVER_TAX_ID SHIPFROM_TAX_ID

Query

SQL_Statement

SELECT elfdh.document_header_id ,elfdh.document_number ,elfdh.access_key_number ,elfdh.source_document_type ,elfdh.document_type ,elfdh.issuer_tax_id ,elfdh.receiver_tax_id ,elfdh.shipfrom_tax_id FROM cmf_fiscal_doc_headers elfdh, cmf_fiscal_proc_options procop WHERE elfdh.document_status = 'VALIDATED' and elfdh.fiscal_proc_options_id=procop.fiscal_proc_options_id and procop.iface_rcv_flag='Y' AND EXISTS (SELECT 1 FROM cmf_fiscal_doc_lines_b elfdl WHERE elfdl.document_header_id = elfdh.document_header_id) AND EXISTS (SELECT 1 FROM cmf_fiscal_doc_lines_b elfdl WHERE elfdl.document_header_id = elfdh.document_header_id AND elfdl.line_status = 'VALIDTD_RECPT_NT_VRFD')