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