CMF_AP_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_doc_ref_attributes elfdra ,cmf_fiscal_doc_headers elrfdh WHERE elfdh.document_status = 'VALIDATED' AND NVL(elfdh.invoice_interfaced_flag,'N') = 'N' AND elfdh.document_type != 'REMITTANCE_FD' AND elfdra.document_header_id(+) = elfdh.document_header_id AND elrfdh.document_header_id(+) = elfdra.ref_document_header_id AND NVL(elrfdh.document_type,'X') != 'REMITTANCE_FD' AND elfdh.schedules_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM cmf_fiscal_proc_options fpo WHERE fpo.fiscal_proc_options_id = elfdh.fiscal_proc_options_id AND fpo.iface_ap_flag = 'Y' ) AND EXISTS (SELECT 1 FROM cmf_fiscal_doc_lines_b elfdl WHERE elfdl.document_header_id = elfdh.document_header_id AND ( elfdl.fd_original_cfop IS NULL OR EXISTS ( SELECT 'X' FROM cmf_fiscal_operation_types fot WHERE fot.fiscal_doc_assoctns_id = elfdh.fiscal_doc_assoctns_id AND fot.fiscal_operation_code = elfdl.fd_original_cfop AND fot.payment_flag = 'Y' ) ) ) AND NOT EXISTS (SELECT 1 FROM cmf_fiscal_doc_lines_b elfdl WHERE elfdl.document_header_id = elfdh.document_header_id AND elfdl.line_status NOT IN ('VALIDTD_RECPT_CNFD','VALIDATED') )