DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_TAR_CONTACT_V

Object Details
Object Name: AMS_TAR_CONTACT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_TAR_CONTACT_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACADEMIC_TITLE VARCHAR2 (500)
DECISION_MAKER VARCHAR2 (500)
DEPARTMENT VARCHAR2 (500)
FIRST_NAME VARCHAR2 (150)
KNOWN_AS VARCHAR2 (500)
LAST_NAME VARCHAR2 (150)
MAIL_STOP VARCHAR2 (500)
MIDDLE_NAME VARCHAR2 (500)
PARTY_ID NUMBER

SUFFIX VARCHAR2 (30)
TITLE VARCHAR2 (150)
BILL_TO_ADDRESS1 VARCHAR2 (500)
BILL_TO_ADDRESS2 VARCHAR2 (500)
BILL_TO_ADDRESS3 VARCHAR2 (500)
BILL_TO_ADDRESS4 VARCHAR2 (500)
BILL_TO_CITY VARCHAR2 (100)
BILL_TO_COUNTRY VARCHAR2 (100)
BILL_TO_POSTAL_CODE VARCHAR2 (100)
BILL_TO_STATE VARCHAR2 (500)
CUSTOMER_KEY VARCHAR2 (500)
DUNS_NUMBER VARCHAR2 (500)
EMAIL_ADDRESS VARCHAR2 (500)
JGZZ_FISCAL_CODE VARCHAR2 (500)
ORGANIZATION_NAME VARCHAR2 (500)
PHONE_NUMBER VARCHAR2 (150)
SHIP_TO_ADDRESS1 VARCHAR2 (500)
SHIP_TO_ADDRESS2 VARCHAR2 (500)
SHIP_TO_ADDRESS3 VARCHAR2 (500)
SHIP_TO_ADDRESS4 VARCHAR2 (500)
SHIP_TO_CITY VARCHAR2 (500)
SHIP_TO_COUNTRY VARCHAR2 (500)
SHIP_TO_POSTAL_CODE VARCHAR2 (500)
SHIP_TO_STATE VARCHAR2 (500)
SIC_CODE VARCHAR2 (500)
TAX_NAME VARCHAR2 (500)
TAX_REFERENCE VARCHAR2 (500)
LIST_ENTRY_ID NUMBER
Yes
LIST_HEADER_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9)
LIST_SELECT_ACTION_ID NUMBER
Yes
ARC_LIST_SELECT_ACTION_FROM VARCHAR2 (30) Yes
LIST_SELECT_ACTION_FROM_NAME VARCHAR2 (254)
SOURCE_CODE VARCHAR2 (30) Yes
ARC_LIST_USED_BY_SOURCE VARCHAR2 (30) Yes
PIN_CODE VARCHAR2 (30) Yes
LIST_ENTRY_SOURCE_SYSTEM_ID NUMBER
Yes
LIST_ENTRY_SOURCE_SYSTEM_TYPE VARCHAR2 (30) Yes
VIEW_APPLICATION_ID NUMBER
Yes
MANUALLY_ENTERED_FLAG VARCHAR2 (1) Yes
MARKED_AS_DUPLICATE_FLAG VARCHAR2 (1) Yes
MARKED_AS_RANDOM_FLAG VARCHAR2 (1) Yes
PART_OF_CONTROL_GROUP_FLAG VARCHAR2 (1) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
CELL_CODE VARCHAR2 (30)
CAMPAIGN_ID NUMBER

MEDIA_ID NUMBER

CHANNEL_ID NUMBER

CHANNEL_SCHEDULE_ID NUMBER

EVENT_OFFER_ID NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACADEMIC_TITLE
,      DECISION_MAKER
,      DEPARTMENT
,      FIRST_NAME
,      KNOWN_AS
,      LAST_NAME
,      MAIL_STOP
,      MIDDLE_NAME
,      PARTY_ID
,      SUFFIX
,      TITLE
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_COUNTRY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_STATE
,      CUSTOMER_KEY
,      DUNS_NUMBER
,      EMAIL_ADDRESS
,      JGZZ_FISCAL_CODE
,      ORGANIZATION_NAME
,      PHONE_NUMBER
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_COUNTRY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_STATE
,      SIC_CODE
,      TAX_NAME
,      TAX_REFERENCE
,      LIST_ENTRY_ID
,      LIST_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      LIST_SELECT_ACTION_ID
,      ARC_LIST_SELECT_ACTION_FROM
,      LIST_SELECT_ACTION_FROM_NAME
,      SOURCE_CODE
,      ARC_LIST_USED_BY_SOURCE
,      PIN_CODE
,      LIST_ENTRY_SOURCE_SYSTEM_ID
,      LIST_ENTRY_SOURCE_SYSTEM_TYPE
,      VIEW_APPLICATION_ID
,      MANUALLY_ENTERED_FLAG
,      MARKED_AS_DUPLICATE_FLAG
,      MARKED_AS_RANDOM_FLAG
,      PART_OF_CONTROL_GROUP_FLAG
,      ENABLED_FLAG
,      CELL_CODE
,      CAMPAIGN_ID
,      MEDIA_ID
,      CHANNEL_ID
,      CHANNEL_SCHEDULE_ID
,      EVENT_OFFER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.AMS_TAR_CONTACT_V;

Dependencies

[top of page]

APPS.AMS_TAR_CONTACT_V references the following:

SchemaAPPS
SynonymAMS_LIST_ENTRIES

APPS.AMS_TAR_CONTACT_V is not referenced by any database object