VIEW: APPS.AMS_TAR_ACCOUNT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'