[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_TAR_PERSON_LIST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LIST_ENTRY_ID | NUMBER | Yes | ||
| LIST_HEADER_ID | NUMBER | Yes | ||
| LIST_SELECT_ACTION_ID | NUMBER | Yes | ||
| SOURCE_CODE_FOR_ID | NUMBER | (30) | Yes | |
| LIST_ENTRY_SOURCE_SYSTEM_ID | NUMBER | Yes | ||
| PARTY_ID | NUMBER | |||
| PARTY_NAME | VARCHAR2 | (500) | ||
| CURR_CP_TIME_ZONE | NUMBER | |||
| CURR_CP_ID | NUMBER | |||
| CURR_CP_COUNTRY_CODE | VARCHAR2 | (30) | ||
| CURR_CP_INDEX | NUMBER | |||
| CURR_CP_AREA_CODE | NUMBER | |||
| CURR_CP_PHONE_NUMBER | VARCHAR2 | (10) | ||
| CURR_CP_RAW_PHONE_NUMBER | VARCHAR2 | (60) | ||
| NEXT_CALL_TIME | DATE | |||
| DO_NOT_USE_FLAG | VARCHAR2 | (1) | ||
| CALLBACK_FLAG | VARCHAR2 | (1) | ||
| RECORD_OUT_FLAG | VARCHAR2 | (1) | ||
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| NEWLY_UPDATED_FLAG | VARCHAR2 | (1) | ||
| PIN_CODE | VARCHAR2 | (30) | Yes | |
| CURR_CP_TIME_ZONE_AUX | NUMBER | |||
| DO_NOT_USE_REASON | VARCHAR2 | (30) | ||
| RECORD_RELEASE_TIME | DATE | |||
| SOURCE_CODE | VARCHAR2 | (30) | Yes | |
| ADDRESS1 | VARCHAR2 | (500) | ||
| ADDRESS2 | VARCHAR2 | (500) | ||
| CITY | VARCHAR2 | (100) | ||
| ADDRESS3 | VARCHAR2 | (500) | ||
| ADDRESS4 | VARCHAR2 | (500) | ||
| COUNTY | VARCHAR2 | (500) | ||
| PROVINCE | VARCHAR2 | (500) | ||
| CUSTOMER_KEY | VARCHAR2 | (500) | ||
| DUNS_NUMBER | VARCHAR2 | (500) | ||
| JGZZ_FISCAL_CODE | VARCHAR2 | (500) | ||
| REFERENCE_USE_FLAG | VARCHAR2 | (500) | ||
| TAX_REFERENCE | VARCHAR2 | (500) | ||
| URL | VARCHAR2 | (500) | ||
| BEST_TIME_CONTACT_BEGIN | VARCHAR2 | (500) | ||
| BEST_TIME_CONTACT_END | VARCHAR2 | (500) | ||
| INTERNAL_FLAG | VARCHAR2 | (500) | ||
| RENT_OWN_IND | VARCHAR2 | (500) | ||
| SALUTATION | VARCHAR2 | (500) | ||
| TOTAL_NUM_OF_ORDERS | VARCHAR2 | (500) | ||
| TOTAL_ORDERED_AMOUNT | VARCHAR2 | (500) | ||
| MAILSTOP | VARCHAR2 | (500) | ||
| PERSON_MIDDLE_NAME | VARCHAR2 | (500) | ||
| AGE | VARCHAR2 | (500) | ||
| DATE_OF_BIRTH | VARCHAR2 | (500) | ||
| DATE_OF_DEATH | VARCHAR2 | (500) | ||
| DECLARED_ETHNICITY | VARCHAR2 | (500) | ||
| HOUSEHOLD_INCOME | VARCHAR2 | (500) | ||
| HOUSEHOLD_SIZE | VARCHAR2 | (500) | ||
| LAST_ORDERED_DATE | VARCHAR2 | (500) | ||
| MARITAL_STATUS | VARCHAR2 | (500) | ||
| MARITAL_STATUS_EFFECTIVE_D | VARCHAR2 | (500) | ||
| PARTY_NUMBER | VARCHAR2 | (500) | ||
| PARTY_SITE_ID | VARCHAR2 | (500) | ||
| PARTY_SITE_NAME | VARCHAR2 | (500) | ||
| PERSON_NAME | VARCHAR2 | (500) | ||
| PERSONAL_INCOME | VARCHAR2 | (500) | ||
| PLACE_OF_BIRTH | VARCHAR2 | (500) | ||
| GENDER | VARCHAR2 | (500) | ||
| LANGUAGE | VARCHAR2 | (500) | ||
| HEAD_OF_HOUSEHOLD_FLAG | VARCHAR2 | (500) | ||
| COUNTRY | VARCHAR2 | (100) | ||
| EMAIL_ADDRESS | VARCHAR2 | (500) | ||
| PERSON_FIRST_NAME | VARCHAR2 | (150) | ||
| PERSON_LAST_NAME | VARCHAR2 | (150) | ||
| STATE | VARCHAR2 | (100) | ||
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | ||
| PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (150) | ||
| POSTAL_CODE | VARCHAR2 | (100) | ||
| CONTACT_POINT_ID_S1 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S1 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S1 | VARCHAR2 | (500) | ||
| REASON_CODE_S1 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S1 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S1 | VARCHAR2 | (500) | ||
| TIME_ZONE_S1 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S1 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S1 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S1 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S1 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S1 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S1 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S1 | VARCHAR2 | (150) | ||
| CONTACT_POINT_ID_S2 | VARCHAR2 | (500) | ||
| TIME_ZONE_S2 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S2 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S2 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S2 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S2 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S2 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S2 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S2 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S2 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S2 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S2 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S2 | VARCHAR2 | (500) | ||
| REASON_CODE_S2 | VARCHAR2 | (500) | ||
| CONTACT_POINT_ID_S3 | VARCHAR2 | (500) | ||
| TIME_ZONE_S3 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S3 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S3 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S3 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S3 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S3 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S3 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S3 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S3 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S3 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S3 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S3 | VARCHAR2 | (500) | ||
| REASON_CODE_S3 | VARCHAR2 | (500) | ||
| CONTACT_POINT_ID_S4 | VARCHAR2 | (500) | ||
| TIME_ZONE_S4 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S4 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S4 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S4 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S4 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S4 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S4 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S4 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S4 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S4 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S4 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S4 | VARCHAR2 | (500) | ||
| REASON_CODE_S4 | VARCHAR2 | (500) | ||
| CONTACT_POINT_ID_S5 | VARCHAR2 | (500) | ||
| TIME_ZONE_S5 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S5 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S5 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S5 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S5 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S5 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S5 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S5 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S5 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S5 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S5 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S5 | VARCHAR2 | (500) | ||
| REASON_CODE_S5 | VARCHAR2 | (500) | ||
| PHONE_EXTENSION_S6 | VARCHAR2 | (500) | ||
| TELEX_NUMBER_S6 | VARCHAR2 | (500) | ||
| PHONE_LINE_TYPE_S6 | VARCHAR2 | (500) | ||
| PREFERENCE_CODE_S6 | VARCHAR2 | (500) | ||
| PHONE_TOUCH_TONE_TYPE_FLAG_S6 | VARCHAR2 | (500) | ||
| PREFERENCE_START_TIME_HR_S6 | VARCHAR2 | (500) | ||
| PREFERENCE_END_TIME_HR_S6 | VARCHAR2 | (500) | ||
| REASON_CODE_S6 | VARCHAR2 | (500) | ||
| CONTACT_POINT_ID_S6 | VARCHAR2 | (500) | ||
| TIME_ZONE_S6 | VARCHAR2 | (500) | ||
| PHONE_NUMBER_S6 | VARCHAR2 | (500) | ||
| RAW_PHONE_NUMBER_S6 | VARCHAR2 | (500) | ||
| PHONE_COUNTRY_CODE_S6 | VARCHAR2 | (500) | ||
| PHONE_AREA_CODE_S6 | VARCHAR2 | (500) | ||
| FAX_PHONE_AREA_CODE_S7 | VARCHAR2 | (500) | ||
| FAX_PHONE_COUNTRY_CODE_S7 | VARCHAR2 | (500) | ||
| TIME_ZONE_S7 | VARCHAR2 | (500) | ||
| FAX_PHONE_NUMBER_S7 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_ENTRY_ID
, LIST_HEADER_ID
, LIST_SELECT_ACTION_ID
, SOURCE_CODE_FOR_ID
, LIST_ENTRY_SOURCE_SYSTEM_ID
, PARTY_ID
, PARTY_NAME
, CURR_CP_TIME_ZONE
, CURR_CP_ID
, CURR_CP_COUNTRY_CODE
, CURR_CP_INDEX
, CURR_CP_AREA_CODE
, CURR_CP_PHONE_NUMBER
, CURR_CP_RAW_PHONE_NUMBER
, NEXT_CALL_TIME
, DO_NOT_USE_FLAG
, CALLBACK_FLAG
, RECORD_OUT_FLAG
, ENABLED_FLAG
, NEWLY_UPDATED_FLAG
, PIN_CODE
, CURR_CP_TIME_ZONE_AUX
, DO_NOT_USE_REASON
, RECORD_RELEASE_TIME
, SOURCE_CODE
, ADDRESS1
, ADDRESS2
, CITY
, ADDRESS3
, ADDRESS4
, COUNTY
, PROVINCE
, CUSTOMER_KEY
, DUNS_NUMBER
, JGZZ_FISCAL_CODE
, REFERENCE_USE_FLAG
, TAX_REFERENCE
, URL
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, INTERNAL_FLAG
, RENT_OWN_IND
, SALUTATION
, TOTAL_NUM_OF_ORDERS
, TOTAL_ORDERED_AMOUNT
, MAILSTOP
, PERSON_MIDDLE_NAME
, AGE
, DATE_OF_BIRTH
, DATE_OF_DEATH
, DECLARED_ETHNICITY
, HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE
, LAST_ORDERED_DATE
, MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_D
, PARTY_NUMBER
, PARTY_SITE_ID
, PARTY_SITE_NAME
, PERSON_NAME
, PERSONAL_INCOME
, PLACE_OF_BIRTH
, GENDER
, LANGUAGE
, HEAD_OF_HOUSEHOLD_FLAG
, COUNTRY
, EMAIL_ADDRESS
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, STATE
, PERSON_NAME_SUFFIX
, PERSON_PRE_NAME_ADJUNCT
, POSTAL_CODE
, CONTACT_POINT_ID_S1
, PREFERENCE_CODE_S1
, PHONE_TOUCH_TONE_TYPE_FLAG_S1
, REASON_CODE_S1
, PREFERENCE_START_TIME_HR_S1
, PREFERENCE_END_TIME_HR_S1
, TIME_ZONE_S1
, RAW_PHONE_NUMBER_S1
, PHONE_COUNTRY_CODE_S1
, PHONE_AREA_CODE_S1
, PHONE_EXTENSION_S1
, TELEX_NUMBER_S1
, PHONE_LINE_TYPE_S1
, PHONE_NUMBER_S1
, CONTACT_POINT_ID_S2
, TIME_ZONE_S2
, PHONE_NUMBER_S2
, RAW_PHONE_NUMBER_S2
, PHONE_COUNTRY_CODE_S2
, PHONE_AREA_CODE_S2
, PHONE_EXTENSION_S2
, TELEX_NUMBER_S2
, PHONE_LINE_TYPE_S2
, PREFERENCE_CODE_S2
, PHONE_TOUCH_TONE_TYPE_FLAG_S2
, PREFERENCE_START_TIME_HR_S2
, PREFERENCE_END_TIME_HR_S2
, REASON_CODE_S2
, CONTACT_POINT_ID_S3
, TIME_ZONE_S3
, PHONE_NUMBER_S3
, RAW_PHONE_NUMBER_S3
, PHONE_COUNTRY_CODE_S3
, PHONE_AREA_CODE_S3
, PHONE_EXTENSION_S3
, TELEX_NUMBER_S3
, PHONE_LINE_TYPE_S3
, PREFERENCE_CODE_S3
, PHONE_TOUCH_TONE_TYPE_FLAG_S3
, PREFERENCE_START_TIME_HR_S3
, PREFERENCE_END_TIME_HR_S3
, REASON_CODE_S3
, CONTACT_POINT_ID_S4
, TIME_ZONE_S4
, PHONE_NUMBER_S4
, RAW_PHONE_NUMBER_S4
, PHONE_COUNTRY_CODE_S4
, PHONE_AREA_CODE_S4
, PHONE_EXTENSION_S4
, TELEX_NUMBER_S4
, PHONE_LINE_TYPE_S4
, PREFERENCE_CODE_S4
, PHONE_TOUCH_TONE_TYPE_FLAG_S4
, PREFERENCE_START_TIME_HR_S4
, PREFERENCE_END_TIME_HR_S4
, REASON_CODE_S4
, CONTACT_POINT_ID_S5
, TIME_ZONE_S5
, PHONE_NUMBER_S5
, RAW_PHONE_NUMBER_S5
, PHONE_COUNTRY_CODE_S5
, PHONE_AREA_CODE_S5
, PHONE_EXTENSION_S5
, TELEX_NUMBER_S5
, PHONE_LINE_TYPE_S5
, PREFERENCE_CODE_S5
, PHONE_TOUCH_TONE_TYPE_FLAG_S5
, PREFERENCE_START_TIME_HR_S5
, PREFERENCE_END_TIME_HR_S5
, REASON_CODE_S5
, PHONE_EXTENSION_S6
, TELEX_NUMBER_S6
, PHONE_LINE_TYPE_S6
, PREFERENCE_CODE_S6
, PHONE_TOUCH_TONE_TYPE_FLAG_S6
, PREFERENCE_START_TIME_HR_S6
, PREFERENCE_END_TIME_HR_S6
, REASON_CODE_S6
, CONTACT_POINT_ID_S6
, TIME_ZONE_S6
, PHONE_NUMBER_S6
, RAW_PHONE_NUMBER_S6
, PHONE_COUNTRY_CODE_S6
, PHONE_AREA_CODE_S6
, FAX_PHONE_AREA_CODE_S7
, FAX_PHONE_COUNTRY_CODE_S7
, TIME_ZONE_S7
, FAX_PHONE_NUMBER_S7
FROM APPS.AMS_TAR_PERSON_LIST_V;
APPS
AMS_LIST_ENTRIES
APPS.AMS_TAR_PERSON_LIST_V is not referenced by any database object
|
|
|
|