CMF_FD_PROC_DOC_ASSOC_V

Details

• Schema: FUSION

• Object owner: CMF

• Object type: VIEW

Columns

Name
FISCAL_PROC_OPTIONS_ID PROCESS_OPTION_CODE DOCUMENT_TYPE_CODE PROCESS_CODE SOURCE_DOCUMENT_TYPE_CODE OPERATION_TYPE FISCAL_DOC_ASSOCTNS_ID FISCAL_OPERATION_CODE ADDITIONAL_MATCH_RULE ISSUER_TYPE RECEIVER_TYPE SHIP_FROM_TYPE SHIP_TO_TYPE CHARGE_ALLOCATION_1_FLAG

Query

SQL_Statement

select procop.FISCAL_PROC_OPTIONS_ID,procop.process_option_code,procop.document_type_code,procop.process_code,procop.source_document_type_code,procop.OPERATION_TYPE,optypes.FISCAL_DOC_ASSOCTNS_ID,optypes.FISCAL_OPERATION_CODE,procop.additional_match_rule,procop.ISSUER_TYPE,procop.RECEIVER_TYPE,procop.ship_from_type,procop.ship_to_type,procop.charge_allocation_1_flag from cmf_fiscal_operation_types optypes ,cmf_fiscal_proc_options procop ,cmf_fiscal_doc_assoctns_b docassoc where procop.FISCAL_PROC_OPTIONS_ID=docassoc.FISCAL_PROC_OPTIONS_ID and docassoc.FISCAL_DOC_ASSOCTNS_ID=optypes.FISCAL_DOC_ASSOCTNS_ID and docassoc.active_flag='Y'