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') |