Export_Sender_Receiver

CREATE OR REPLACE FORCE VIEW Export_Sender_Receiver(ID, EXPORTER_ID, EXPORTER_PERSONAL_NAME, EXPORTER_NAME, RECEIVER_GROUP_ID, RECEIVER_GROUP_NAME, RECEIVER_ID, RECEIVER_PERSONAL_NAME, RECEIVER_NAME, RECEIVER_TYPE) AS SELECT
  S.ID as ID,
  S.ID,
  S.PERSONAL_NAME,
  S.NAME,
  G.ID,
  G.NAME,
  R.ID,
  R.PERSONAL_NAME,
  R.NAME,
  R.BUSINESS_ASSOCIATE_TYPE
FROM
  BA_GROUP G,      -- Group of data receivers
  PERSON S,        -- Sender person
  PERSON R,        -- Receiver person
  BA_ASSOCIATION E,-- Exporter association between Sender and Receiver Group
  BA_ASSOCIATION M -- Member association between Receiver and Receiver Group
WHERE
  S.ID=E.PRIMARY_BA_ID                  AND
  G.ID=E.SECONDARY_BA_ID                AND
  E.BA_ASSOCIATION_ROLE_CODE='Exporter' AND
  R.ID=M.PRIMARY_BA_ID                  AND
  G.ID=M.SECONDARY_BA_ID                AND
  M.BA_ASSOCIATION_ROLE_CODE='Member'
ORDER BY
  S.NAME, S.PERSONAL_NAME, G.NAME, R.NAME, R.PERSONAL_NAME