[Home] [Help] [Dependency Information]
Object Name: | AMS_TAR_ACCOUNT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_TAR_ACCOUNT_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.AMS_TAR_ACCOUNT_V is not referenced by any database object
|
|
|