VIEW: APPS.AST_PERSON_INTEREST_V

Source

View Text - Preformatted

SELECT HZ.ROWID , HZ.PERSON_INTEREST_ID , HZ.LEVEL_OF_INTEREST , HZ.PARTY_ID , HZ.LEVEL_OF_PARTICIPATION , LKUP1.MEANING , HZ.INTEREST_TYPE_CODE , LKUP2.MEANING , HZ.COMMENTS , HZ.SPORT_INDICATOR , HZ.SUB_INTEREST_TYPE_CODE , HZ.INTEREST_NAME , HZ.TEAM , HZ.SINCE , HZ.CREATED_BY , HZ.CREATION_DATE , HZ.LAST_UPDATE_LOGIN , HZ.LAST_UPDATE_DATE , HZ.LAST_UPDATED_BY , HZ.REQUEST_ID , HZ.PROGRAM_APPLICATION_ID , HZ.PROGRAM_ID , HZ.PROGRAM_UPDATE_DATE , CREATED_BY_MODULE , APPLICATION_ID , OBJECT_VERSION_NUMBER , HZ.STATUS , LKUP3.MEANING FROM HZ_PERSON_INTEREST HZ , AR_LOOKUPS LKUP1 , AR_LOOKUPS LKUP2 , AR_LOOKUPS LKUP3 WHERE hz.LEVEL_OF_PARTICIPATION = LKUP1.LOOKUP_CODE(+) AND LKUP1.LOOKUP_TYPE(+) = 'PARTICIPATION_LEVEL' AND HZ.INTEREST_TYPE_CODE = LKUP2.LOOKUP_CODE(+) AND LKUP2.LOOKUP_TYPE(+) = 'INTEREST_TYPE' AND LKUP3.LOOKUP_TYPE(+) = 'REGISTRY_STATUS' AND LKUP3.LOOKUP_CODE(+) = HZ.STATUS AND HZ.STATUS IN ('A' , 'I' )

View Text - HTML Formatted

SELECT HZ.ROWID
, HZ.PERSON_INTEREST_ID
, HZ.LEVEL_OF_INTEREST
, HZ.PARTY_ID
, HZ.LEVEL_OF_PARTICIPATION
, LKUP1.MEANING
, HZ.INTEREST_TYPE_CODE
, LKUP2.MEANING
, HZ.COMMENTS
, HZ.SPORT_INDICATOR
, HZ.SUB_INTEREST_TYPE_CODE
, HZ.INTEREST_NAME
, HZ.TEAM
, HZ.SINCE
, HZ.CREATED_BY
, HZ.CREATION_DATE
, HZ.LAST_UPDATE_LOGIN
, HZ.LAST_UPDATE_DATE
, HZ.LAST_UPDATED_BY
, HZ.REQUEST_ID
, HZ.PROGRAM_APPLICATION_ID
, HZ.PROGRAM_ID
, HZ.PROGRAM_UPDATE_DATE
, CREATED_BY_MODULE
, APPLICATION_ID
, OBJECT_VERSION_NUMBER
, HZ.STATUS
, LKUP3.MEANING
FROM HZ_PERSON_INTEREST HZ
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, AR_LOOKUPS LKUP3
WHERE HZ.LEVEL_OF_PARTICIPATION = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'PARTICIPATION_LEVEL'
AND HZ.INTEREST_TYPE_CODE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'INTEREST_TYPE'
AND LKUP3.LOOKUP_TYPE(+) = 'REGISTRY_STATUS'
AND LKUP3.LOOKUP_CODE(+) = HZ.STATUS
AND HZ.STATUS IN ('A'
, 'I' )