TRIGGER FETCHES ONLY FEW RECORDS
WE ARE CREATING A TRIGGER ON JTF_IH_INTERACTIONS TABLE, THAT AIMS TO CATCH THE INTERACTION DETAILS LIKE INTERACTION_ID,PARTY_ID,RESULT_ID,REASON_ID,OUTCOME_ID once a interaction is created using front end.Further we join the id details to the tables like jtf_ih_reasons_tl ,jtf_ih_outcomes_tl,hz_parties to fetch the column short _description.
the code attched works fine (see sample output),but the reason result outcome fields do not populate..Can any one suggest?
the code attched works fine (see sample output),but the reason result outcome fields do not populate..Can any one suggest?
0