eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AMS_TAR_ACCOUNT_V

Object Details

Object Name:	AMS_TAR_ACCOUNT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_TAR_ACCOUNT_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCOUNT_ACTIVATION_DATE	VARCHAR2	(500)
ACCOUNT_ESTABLISHED_DATE	VARCHAR2	(500)
ACCOUNT_NAME	VARCHAR2	(500)
ACCOUNT_NUMBER	VARCHAR2	(500)
ACCOUNT_TERMINATION_DATE	VARCHAR2	(500)
CUSTOMER_CLASS_CODE	VARCHAR2	(500)
CUSTOMER_TYPE	VARCHAR2	(500)
MAJOR_ACCOUNT_NUMBER	VARCHAR2	(500)
STATUS	VARCHAR2	(500)
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_FIRST_NAME	VARCHAR2	(500)
BILL_TO_LAST_NAME	VARCHAR2	(500)
BILL_TO_NAME	VARCHAR2	(500)
BILL_TO_NAME_SUFFIX	VARCHAR2	(500)
BILL_TO_NAME_TYPE	VARCHAR2	(500)
BILL_TO_POSTAL_CODE_	VARCHAR2	(100)
BILL_TO_STATE	VARCHAR2	(100)
BILL_TO_TITLE	VARCHAR2	(500)
CONTACT_ADDRESS1	VARCHAR2	(500)
CONTACT_ADDRESS2	VARCHAR2	(500)
CONTACT_ADDRESS3	VARCHAR2	(500)
CONTACT_ADDRESS4	VARCHAR2	(500)
CONTACT_CITY	VARCHAR2	(500)
CONTACT_COUNTRY	VARCHAR2	(500)
CONTACT_FIRST_NAME	VARCHAR2	(150)
CONTACT_LAST_NAME	VARCHAR2	(150)
CONTACT_POSTAL_CODE	VARCHAR2	(500)
CONTACT_STATE	VARCHAR2	(500)
CONTACT_SUFFIX	VARCHAR2	(30)
CONTACT_TITLE	VARCHAR2	(150)
GUARANTOR_ADDRESS1	VARCHAR2	(500)
GUARANTOR_ADDRESS2	VARCHAR2	(500)
GUARANTOR_ADDRESS3	VARCHAR2	(500)
GUARANTOR_ADDRESS4	VARCHAR2	(500)
GUARANTOR_CITY	VARCHAR2	(500)
GUARANTOR_COUNTRY	VARCHAR2	(500)
GUARANTOR_FIRST_NAME	VARCHAR2	(500)
GUARANTOR_LAST_NAME	VARCHAR2	(500)
GUARANTOR_NAME	VARCHAR2	(500)
GUARANTOR_NUMBER	VARCHAR2	(500)
GUARANTOR_POSTAL_CODE	VARCHAR2	(500)
GUARANTOR_STATE	VARCHAR2	(500)
GUARANTOR_SUFFIX	VARCHAR2	(500)
GUARANTOR_TYPE	VARCHAR2	(500)
PARTY_ID	NUMBER
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_FIRST_NAME	VARCHAR2	(500)
SHIP_TO_LAST_NAME	VARCHAR2	(500)
SHIP_TO_NAME	VARCHAR2	(500)
SHIP_TO_POSTAL_CODE	VARCHAR2	(500)
SHIP_TO_STATE	VARCHAR2	(500)
SHIP_TO_SUFFIX	VARCHAR2	(500)
SHIP_TO_TITLE	VARCHAR2	(500)
SHIP_TO_TYPE	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 ACCOUNT_ACTIVATION_DATE
,      ACCOUNT_ESTABLISHED_DATE
,      ACCOUNT_NAME
,      ACCOUNT_NUMBER
,      ACCOUNT_TERMINATION_DATE
,      CUSTOMER_CLASS_CODE
,      CUSTOMER_TYPE
,      MAJOR_ACCOUNT_NUMBER
,      STATUS
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_COUNTRY
,      BILL_TO_FIRST_NAME
,      BILL_TO_LAST_NAME
,      BILL_TO_NAME
,      BILL_TO_NAME_SUFFIX
,      BILL_TO_NAME_TYPE
,      BILL_TO_POSTAL_CODE_
,      BILL_TO_STATE
,      BILL_TO_TITLE
,      CONTACT_ADDRESS1
,      CONTACT_ADDRESS2
,      CONTACT_ADDRESS3
,      CONTACT_ADDRESS4
,      CONTACT_CITY
,      CONTACT_COUNTRY
,      CONTACT_FIRST_NAME
,      CONTACT_LAST_NAME
,      CONTACT_POSTAL_CODE
,      CONTACT_STATE
,      CONTACT_SUFFIX
,      CONTACT_TITLE
,      GUARANTOR_ADDRESS1
,      GUARANTOR_ADDRESS2
,      GUARANTOR_ADDRESS3
,      GUARANTOR_ADDRESS4
,      GUARANTOR_CITY
,      GUARANTOR_COUNTRY
,      GUARANTOR_FIRST_NAME
,      GUARANTOR_LAST_NAME
,      GUARANTOR_NAME
,      GUARANTOR_NUMBER
,      GUARANTOR_POSTAL_CODE
,      GUARANTOR_STATE
,      GUARANTOR_SUFFIX
,      GUARANTOR_TYPE
,      PARTY_ID
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_COUNTRY
,      SHIP_TO_FIRST_NAME
,      SHIP_TO_LAST_NAME
,      SHIP_TO_NAME
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_STATE
,      SHIP_TO_SUFFIX
,      SHIP_TO_TITLE
,      SHIP_TO_TYPE
,      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_ACCOUNT_V;

Dependencies

[top of page]

APPS.AMS_TAR_ACCOUNT_V references the following:

APPS: AMS_LIST_ENTRIES

APPS.AMS_TAR_ACCOUNT_V is not referenced by any database object