[Home] [Help] [Dependency Information]
Object Name: | AMS_TAR_ORGANIZATION_CONTACT_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) | ||
TITLE | 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) | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (500) | ||
MAIL_STOP | VARCHAR2 | (500) | ||
PERSON_MIDDLE_NAME | VARCHAR2 | (500) | ||
DEPARTMENT | VARCHAR2 | (500) | ||
CONTACT_ID | VARCHAR2 | (500) | ||
PARTY_CONTACT_NAME | VARCHAR2 | (500) | ||
CONTACT_NUMBER | VARCHAR2 | (500) | ||
DECISION_MAKER_FLAG | VARCHAR2 | (500) | ||
DEPARTMENT_CODE | VARCHAR2 | (500) | ||
JOB_TITLE | VARCHAR2 | (500) | ||
JOB_TITLE_CODE | VARCHAR2 | (500) | ||
MANAGED_BY | VARCHAR2 | (500) | ||
ORGANIZATION_ID | VARCHAR2 | (500) | ||
PERSON_ACADEMIC_TITLE | VARCHAR2 | (500) | ||
PERSON_IDEN_TYPE | VARCHAR2 | (500) | ||
PERSON_IDENTIFIER | VARCHAR2 | (500) | ||
PARTY_SITE_ID | VARCHAR2 | (500) | ||
PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (500) | ||
RANK | VARCHAR2 | (500) | ||
GROUP_TYPE | VARCHAR2 | (500) | ||
HQ_BRANCH_IND | VARCHAR2 | (500) | ||
KNOWN_AS | VARCHAR2 | (500) | ||
SIC_CODE | VARCHAR2 | (500) | ||
SIC_CODE_TYPE | VARCHAR2 | (500) | ||
STATUS | VARCHAR2 | (500) | ||
TAX_NAME | VARCHAR2 | (500) | ||
VALIDATED_FLAG | VARCHAR2 | (500) | ||
ROLE_TYPE | VARCHAR2 | (500) | ||
RELATIONSHIP_CODE | VARCHAR2 | (500) | ||
GENDER | VARCHAR2 | (500) | ||
NATIVE_LANGUAGE | 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) | ||
UNDER_SHIPMENT_TOLERANCE_S7 | VARCHAR2 | (500) | ||
FAX_PHONE_AREA_CODE_S8 | VARCHAR2 | (500) | ||
FAX_PHONE_COUNTRY_CODE_S8 | VARCHAR2 | (500) | ||
TIME_ZONE_S8 | VARCHAR2 | (500) | ||
FAX_PHONE_NUMBER_S8 | VARCHAR2 | (150) | ||
CUSTOMER_KEY_S9 | VARCHAR2 | (500) | ||
URL_S9 | VARCHAR2 | (500) | ||
TOTAL_NUM_OF_ORDERS_S9 | VARCHAR2 | (500) | ||
TOTAL_ORDERED_AMOUNT_S9 | VARCHAR2 | (500) | ||
PARTY_ID_S9 | VARCHAR2 | (500) | ||
ORGANIZATION_NAME_S9 | VARCHAR2 | (500) | ||
SIC_CODE_S10 | VARCHAR2 | (500) | ||
FISCAL_YEAREND_MONTH_S10 | VARCHAR2 | (500) | ||
EMPLOYEES_TOTAL_S10 | VARCHAR2 | (500) | ||
CURR_FY_POTENTIAL_REVENUE_S10 | VARCHAR2 | (500) |
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
, TITLE
, PROVINCE
, CUSTOMER_KEY
, DUNS_NUMBER
, JGZZ_FISCAL_CODE
, REFERENCE_USE_FLAG
, TAX_REFERENCE
, URL
, ORIG_SYSTEM_REFERENCE
, MAIL_STOP
, PERSON_MIDDLE_NAME
, DEPARTMENT
, CONTACT_ID
, PARTY_CONTACT_NAME
, CONTACT_NUMBER
, DECISION_MAKER_FLAG
, DEPARTMENT_CODE
, JOB_TITLE
, JOB_TITLE_CODE
, MANAGED_BY
, ORGANIZATION_ID
, PERSON_ACADEMIC_TITLE
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, PARTY_SITE_ID
, PERSON_PREVIOUS_LAST_NAME
, RANK
, GROUP_TYPE
, HQ_BRANCH_IND
, KNOWN_AS
, SIC_CODE
, SIC_CODE_TYPE
, STATUS
, TAX_NAME
, VALIDATED_FLAG
, ROLE_TYPE
, RELATIONSHIP_CODE
, GENDER
, NATIVE_LANGUAGE
, 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
, UNDER_SHIPMENT_TOLERANCE_S7
, FAX_PHONE_AREA_CODE_S8
, FAX_PHONE_COUNTRY_CODE_S8
, TIME_ZONE_S8
, FAX_PHONE_NUMBER_S8
, CUSTOMER_KEY_S9
, URL_S9
, TOTAL_NUM_OF_ORDERS_S9
, TOTAL_ORDERED_AMOUNT_S9
, PARTY_ID_S9
, ORGANIZATION_NAME_S9
, SIC_CODE_S10
, FISCAL_YEAREND_MONTH_S10
, EMPLOYEES_TOTAL_S10
, CURR_FY_POTENTIAL_REVENUE_S10
FROM APPS.AMS_TAR_ORGANIZATION_CONTACT_V;
APPS.AMS_TAR_ORGANIZATION_CONTACT_V is not referenced by any database object
|
|
|