Product: | AMS - Marketing |
---|---|
Description: | This View shows the information stored for an "AMS_ACCOUNT" List source type. |
Implementation/DBA Data: | APPS.AMS_TAR_ACCOUNT_V |
SELECT COL8 ACCOUNT_ACTIVATION_DATE
, COL7 ACCOUNT_ESTABLISHED_DATE
, COL1 ACCOUNT_NAME
, COL2 ACCOUNT_NUMBER
, COL9 ACCOUNT_TERMINATION_DATE
, COL5 CUSTOMER_CLASS_CODE
, COL4 CUSTOMER_TYPE
, COL6 MAJOR_ACCOUNT_NUMBER
, COL3 STATUS
, ADDRESS_LINE1 BILL_TO_ADDRESS1
, ADDRESS_LINE2 BILL_TO_ADDRESS2
, COL10 BILL_TO_ADDRESS3
, COL11 BILL_TO_ADDRESS4
, CITY BILL_TO_CITY
, COUNTRY BILL_TO_COUNTRY
, COL12 BILL_TO_FIRST_NAME
, COL13 BILL_TO_LAST_NAME
, COL16 BILL_TO_NAME
, COL14 BILL_TO_NAME_SUFFIX
, COL17 BILL_TO_NAME_TYPE
, ZIPCODE BILL_TO_POSTAL_CODE_
, STATE BILL_TO_STATE
, COL15 BILL_TO_TITLE
, COL32 CONTACT_ADDRESS1
, COL33 CONTACT_ADDRESS2
, COL34 CONTACT_ADDRESS3
, COL35 CONTACT_ADDRESS4
, COL36 CONTACT_CITY
, COL39 CONTACT_COUNTRY
, FIRST_NAME CONTACT_FIRST_NAME
, LAST_NAME CONTACT_LAST_NAME
, COL38 CONTACT_POSTAL_CODE
, COL37 CONTACT_STATE
, SUFFIX CONTACT_SUFFIX
, TITLE CONTACT_TITLE
, COL40 GUARANTOR_ADDRESS1
, COL41 GUARANTOR_ADDRESS2
, COL42 GUARANTOR_ADDRESS3
, COL43 GUARANTOR_ADDRESS4
, COL44 GUARANTOR_CITY
, COL47 GUARANTOR_COUNTRY
, COL51 GUARANTOR_FIRST_NAME
, COL52 GUARANTOR_LAST_NAME
, COL48 GUARANTOR_NAME
, COL49 GUARANTOR_NUMBER
, COL46 GUARANTOR_POSTAL_CODE
, COL45 GUARANTOR_STATE
, COL53 GUARANTOR_SUFFIX
, COL50 GUARANTOR_TYPE
, PARTY_ID PARTY_ID
, COL18 SHIP_TO_ADDRESS1
, COL19 SHIP_TO_ADDRESS2
, COL20 SHIP_TO_ADDRESS3
, COL21 SHIP_TO_ADDRESS4
, COL22 SHIP_TO_CITY
, COL24 SHIP_TO_COUNTRY
, COL28 SHIP_TO_FIRST_NAME
, COL29 SHIP_TO_LAST_NAME
, COL26 SHIP_TO_NAME
, COL25 SHIP_TO_POSTAL_CODE
, COL23 SHIP_TO_STATE
, COL30 SHIP_TO_SUFFIX
, COL31 SHIP_TO_TITLE
, COL27 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 AMS_LIST_ENTRIES
WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE ='AMS_ACCOUNT'