[Home] [Help]
[Dependency Information]
[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_LIST_ENTRIES
APPS.AMS_TAR_ORGANIZATION_CONTACT_V is not referenced by any database object
|
|
|
|