View: OKL_CS_INTERACTIONS_PARTY_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_INTERACTIONS_PARTY_UV

View Text

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')

Columns