Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_CS_IH_ACTIVITIES_UV |
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