Retrieve Service Agreement Linked to Service Point / Field Activity
SELECT
A.SA_ID,
A.SA_SP_FA_TYPE_FLG,
C.PER_ID,
B.ACCT_ID
FROM
CI_SA_SP_FA A,
CI_SA B,
CI_ACCT_PER C
WHERE A.FA_ID = 'INSERT_FIELD_ACTIVITY_ID'
AND A.SA_ID = B.SA_ID
AND B.ACCT_ID = C.ACCT_ID
AND C.MAIN_CUST_SW = 'Y'