VIEW: APPS.OKL_CS_IH_ACTIVITIES_UV

Source

View Text - Preformatted

SELECT act.doc_id CONTRACT_ID, cip.party_id PARTY_ID, cip.interaction_id INTERACTION_ID, AI.ACTION_ITEM_ID ACTION_ITEM_ID, AI.SHORT_DESCRIPTION ACTION_ITEM_DESC, ACT.OUTCOME_CODE OUTCOME_CODE, ACT.OUT_DESC OUTCOME_DESC, OTC.SHORT_DESCRIPTION OUTCOME_MEANING, ACT.RESULT_CODE RESULT_CODE, ACT.RSL_DESC RESULT_DESCRIPTION, ACT.REASON_CODE REASON_CODE, ACT.REA_DESC REASON_DESC, ACT.RESOURCE_NAME RESOURCE_NAME, ACT.DURATION DURATION, ACT.START_DATE_TIME START_DATE, ACT.END_DATE_TIME END_DATE, INT.FOLLOW_UP_ACTION FOLLOWUP_ACTION, ACT.DOC_SOURCE_OBJECT_NAME DOC_SOURCE FROM JTF_IH_ACTIVITIES_VL ACT,JTF_IH_ACTION_ITEMS_VL AI,JTF_IH_INTERACTIONS_V INT,JTF_IH_OUTCOMES_VL OTC,OKL_CS_INTERACTIONS_PARTY_UV CIP WHERE cip.interaction_id = INT.interaction_id AND act.interaction_id = INT.interaction_id AND act.action_item_id = ai.action_item_id AND act.outcome_id = otc.outcome_id ORDER BY ACT.END_DATE_TIME,ACT.START_DATE_TIME

View Text - HTML Formatted

SELECT ACT.DOC_ID CONTRACT_ID
, CIP.PARTY_ID PARTY_ID
, CIP.INTERACTION_ID INTERACTION_ID
, AI.ACTION_ITEM_ID ACTION_ITEM_ID
, AI.SHORT_DESCRIPTION ACTION_ITEM_DESC
, ACT.OUTCOME_CODE OUTCOME_CODE
, ACT.OUT_DESC OUTCOME_DESC
, OTC.SHORT_DESCRIPTION OUTCOME_MEANING
, ACT.RESULT_CODE RESULT_CODE
, ACT.RSL_DESC RESULT_DESCRIPTION
, ACT.REASON_CODE REASON_CODE
, ACT.REA_DESC REASON_DESC
, ACT.RESOURCE_NAME RESOURCE_NAME
, ACT.DURATION DURATION
, ACT.START_DATE_TIME START_DATE
, ACT.END_DATE_TIME END_DATE
, INT.FOLLOW_UP_ACTION FOLLOWUP_ACTION
, ACT.DOC_SOURCE_OBJECT_NAME DOC_SOURCE
FROM JTF_IH_ACTIVITIES_VL ACT
, JTF_IH_ACTION_ITEMS_VL AI
, JTF_IH_INTERACTIONS_V INT
, JTF_IH_OUTCOMES_VL OTC
, OKL_CS_INTERACTIONS_PARTY_UV CIP
WHERE CIP.INTERACTION_ID = INT.INTERACTION_ID
AND ACT.INTERACTION_ID = INT.INTERACTION_ID
AND ACT.ACTION_ITEM_ID = AI.ACTION_ITEM_ID
AND ACT.OUTCOME_ID = OTC.OUTCOME_ID ORDER BY ACT.END_DATE_TIME
, ACT.START_DATE_TIME