FOS_FLOW_INSTANCE_REF_V

Details

• Schema: FUSION

• Object owner: FOS

• Object type: VIEW

Columns

Name
FLOW_INSTANCE_ID TRANSACTION_ID

Query

SQL_Statement

SELECT fi.flow_instance_id, pte.event_data_id transaction_id FROM fos_flow_instances fi, fos_agreement_ftr_f ftr , fos_txn_events te, fos_txn_events pte WHERE fi.agreement_ftr_id = ftr.agreement_ftr_id AND ftr.agreement_ftr_id = (SELECT MAX(agreement_ftr_id) FROM fos_agreement_ftr_f f where f.agreement_ptr_id = ftr.agreement_ptr_id) AND fi.transaction_type = 'RECEIPT_ACCRUAL' AND fi.event_definition_id = 1700 AND fi.event_data_id = te.event_data_id AND fi.event_definition_id = te.event_definition_id AND fi.system_id = te.system_id AND te.event_data_id = pte.parent_event_data_id AND te.event_definition_id = pte.parent_event_definition_id AND te.system_id = pte.parent_event_system_id AND (fi.tax_calculation_status IN ('NOT_NEEDED','CALCULATED') OR fi.tax_calculation_status IS NULL) UNION ALL SELECT fi.flow_instance_id, te.event_data_id transaction_id FROM fos_flow_instances fi, fos_agreement_ftr_f ftr , fos_txn_events te WHERE fi.agreement_ftr_id = ftr.agreement_ftr_id AND ftr.agreement_ftr_id = (SELECT MAX(agreement_ftr_id) FROM fos_agreement_ftr_f f where f.agreement_ptr_id = ftr.agreement_ptr_id) AND fi.transaction_type = 'RECEIPT_ACCRUAL' AND fi.event_definition_id = 1800 AND fi.event_data_id = te.event_data_id AND fi.event_definition_id = te.event_definition_id AND fi.system_id = te.system_id AND (fi.tax_calculation_status IN ('NOT_NEEDED','CALCULATED') OR fi.tax_calculation_status IS NULL)