[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_TAR_ORGANIZATION_CONTACT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
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
|
|
|
|