[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

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_LIST_ENTRIES

APPS.AMS_TAR_ACCOUNT_V is not referenced by any database object