VIEW: APPS.OKL_CS_INTERACTIONS_PARTY_UV

Source

View Text - Preformatted

SELECT ihi.interaction_id interaction_id, ihi.party_id party_id, p.effective_start_date start_date, p.effective_end_date end_date, res.resource_id resource_id, 'RS_RESOURCE' resource_type FROM JTF_IH_INTERACTIONS IHI,JTF_RS_RESOURCE_EXTNS RES,PER_PEOPLE_F P,FND_APPLICATION_VL APP,JTF_IH_OUTCOMES_TL O,JTF_IH_RESULTS_TL RU,JTF_IH_REASONS_TL RE,JTF_IH_ACTIVITIES_VL IHA WHERE app.application_id = ihi.handler_id AND res.resource_id = ihi.resource_id AND RES.SOURCE_ID = P.PERSON_ID AND TRUNC(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date AND ihi.outcome_id = o.outcome_id(+) AND ru.result_id(+) = ihi.result_id AND ihi.reason_id = re.reason_id (+) AND o.LANGUAGE(+) = USERENV('LANG') AND ru.LANGUAGE(+) = USERENV('LANG') AND re.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT IHI.INTERACTION_ID INTERACTION_ID
, IHI.PARTY_ID PARTY_ID
, P.EFFECTIVE_START_DATE START_DATE
, P.EFFECTIVE_END_DATE END_DATE
, RES.RESOURCE_ID RESOURCE_ID
, 'RS_RESOURCE' RESOURCE_TYPE
FROM JTF_IH_INTERACTIONS IHI
, JTF_RS_RESOURCE_EXTNS RES
, PER_PEOPLE_F P
, FND_APPLICATION_VL APP
, JTF_IH_OUTCOMES_TL O
, JTF_IH_RESULTS_TL RU
, JTF_IH_REASONS_TL RE
, JTF_IH_ACTIVITIES_VL IHA
WHERE APP.APPLICATION_ID = IHI.HANDLER_ID
AND RES.RESOURCE_ID = IHI.RESOURCE_ID
AND RES.SOURCE_ID = P.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND IHI.OUTCOME_ID = O.OUTCOME_ID(+)
AND RU.RESULT_ID(+) = IHI.RESULT_ID
AND IHI.REASON_ID = RE.REASON_ID (+)
AND O.LANGUAGE(+) = USERENV('LANG')
AND RU.LANGUAGE(+) = USERENV('LANG')
AND RE.LANGUAGE(+) = USERENV('LANG')