Product: | CSC - Customer Care |
---|---|
Description: | View of HZ_PERSON_INTEREST. This view is used to get person interests |
Implementation/DBA Data: | APPS.CSC_HZ_PERSON_INTEREST_V |
SELECT INT.PERSON_INTEREST_ID
, INT.LEVEL_OF_INTEREST
, INT.PARTY_ID
, INT.LEVEL_OF_PARTICIPATION
, INT.INTEREST_TYPE_CODE
, ARL.MEANING
, INT.COMMENTS
, INT.SPORT_INDICATOR
, INT.SUB_INTEREST_TYPE_CODE
, ARL_SUB.MEANING
, INT.INTEREST_NAME
, INT.TEAM
, INT.SINCE
, INT.CREATED_BY
, INT.CREATION_DATE
, INT.LAST_UPDATE_LOGIN
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY
, INT.REQUEST_ID
, INT.PROGRAM_APPLICATION_ID
, INT.PROGRAM_ID
, INT.PROGRAM_UPDATE_DATE
, INT.WH_UPDATE_DATE
, NULL
FROM HZ_PERSON_INTEREST INT
, AR_LOOKUPS ARL
, AR_LOOKUPS ARL_SUB
WHERE ARL.LOOKUP_CODE = INT.INTEREST_TYPE_CODE
AND ARL.LOOKUP_TYPE = 'INTEREST_TYPE'
AND ARL_SUB.LOOKUP_TYPE (+) = INT.INTEREST_TYPE_CODE
AND ARL_SUB.LOOKUP_CODE (+) = INT.SUB_INTEREST_TYPE_CODE