VIEW: APPS.CSC_HZ_PERSON_INTEREST_V

Source

View Text - Preformatted

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 , INT.OBJECT_VERSION_NUMBER 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 AND INT.STATUS='A'

View Text - HTML Formatted

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
, INT.OBJECT_VERSION_NUMBER
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
AND INT.STATUS='A'