View: AST_PERSON_INTEREST_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_PERSON_INTEREST_V

View Text

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

Columns