[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_TAR_PERSON_LIST_V is not referenced by any database object
|
|
|