FUN_INTERCO_MASTER_ORGS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
MASTER_DOCUMENT_ID INTERCO_ORG_ID

Query

SQL_Statement

SELECT master_document_id, provider_org_id interco_org_id FROM fun_interco_master_documents UNION ALL SELECT master_document_id, clearing_org1_id interco_org_id FROM fun_interco_master_documents WHERE clearing_org1_id is not null UNION ALL SELECT master_document_id, clearing_org2_id interco_org_id FROM fun_interco_master_documents WHERE clearing_org2_id is not null UNION ALL SELECT master_document_id, clearing_org3_id interco_org_id FROM fun_interco_master_documents WHERE clearing_org3_id is not null UNION ALL SELECT master_document_id, clearing_org4_id interco_org_id FROM fun_interco_master_documents WHERE clearing_org4_id is not null UNION ALL SELECT master_document_id, clearing_org5_id interco_org_id FROM fun_interco_master_documents WHERE clearing_org5_id is not null UNION ALL SELECT isdg.master_document_id, isd.receiver_org_id interco_org_id FROM fun_interco_source_doc_groups isdg, fun_interco_source_documents isd WHERE isdg.source_doc_group_id = isd.source_doc_group_id AND isdg.template_flag = 'Y'