DBA Data[Home] [Help]

VIEW: AR.HZ_PERSON_INTEREST#

Source

View Text - Preformatted

select PERSON_INTEREST_ID PERSON_INTEREST_ID, LEVEL_OF_INTEREST LEVEL_OF_INTEREST, PARTY_ID PARTY_ID, LEVEL_OF_PARTICIPATION LEVEL_OF_PARTICIPATION, INTEREST_TYPE_CODE INTEREST_TYPE_CODE, COMMENTS COMMENTS, SPORT_INDICATOR SPORT_INDICATOR, SUB_INTEREST_TYPE_CODE SUB_INTEREST_TYPE_CODE, INTEREST_NAME INTEREST_NAME, TEAM TEAM, SINCE SINCE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, WH_UPDATE_DATE WH_UPDATE_DATE, STATUS STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, APPLICATION_ID APPLICATION_ID, CREATED_BY_MODULE CREATED_BY_MODULE from "AR"."HZ_PERSON_INTEREST"
View Text - HTML Formatted

SELECT PERSON_INTEREST_ID PERSON_INTEREST_ID
, LEVEL_OF_INTEREST LEVEL_OF_INTEREST
, PARTY_ID PARTY_ID
, LEVEL_OF_PARTICIPATION LEVEL_OF_PARTICIPATION
, INTEREST_TYPE_CODE INTEREST_TYPE_CODE
, COMMENTS COMMENTS
, SPORT_INDICATOR SPORT_INDICATOR
, SUB_INTEREST_TYPE_CODE SUB_INTEREST_TYPE_CODE
, INTEREST_NAME INTEREST_NAME
, TEAM TEAM
, SINCE SINCE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, STATUS STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, APPLICATION_ID APPLICATION_ID
, CREATED_BY_MODULE CREATED_BY_MODULE
FROM "AR"."HZ_PERSON_INTEREST"