VIEW: APPS.AMS_TAR_PERSON_LIST_V

Source

View Text - Preformatted

SELECT LIST_ENTRY_ID LIST_ENTRY_ID  , LIST_HEADER_ID LIST_HEADER_ID  , LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID  , SOURCE_CODE_FOR_ID SOURCE_CODE_FOR_ID  , LIST_ENTRY_SOURCE_SYSTEM_ID LIST_ENTRY_SOURCE_SYSTEM_ID  , PARTY_ID PARTY_ID ,   CUSTOMER_NAME PARTY_NAME ,   CURR_CP_TIME_ZONE CURR_CP_TIME_ZONE ,  CURR_CP_ID CURR_CP_ID  , CURR_CP_COUNTRY_CODE CURR_CP_COUNTRY_CODE ,  CURR_CP_INDEX CURR_CP_INDEX  , CURR_CP_AREA_CODE CURR_CP_AREA_CODE ,  CURR_CP_PHONE_NUMBER CURR_CP_PHONE_NUMBER ,  CURR_CP_RAW_PHONE_NUMBER CURR_CP_RAW_PHONE_NUMBER ,  NEXT_CALL_TIME NEXT_CALL_TIME  , DO_NOT_USE_FLAG DO_NOT_USE_FLAG  , CALLBACK_FLAG CALLBACK_FLAG  , RECORD_OUT_FLAG RECORD_OUT_FLAG ,  ENABLED_FLAG ENABLED_FLAG  , NEWLY_UPDATED_flag  NEWLY_UPDATED_flag   , PIN_CODE PIN_CODE  , CURR_CP_TIME_ZONE_AUX CURR_CP_TIME_ZONE_AUX , DO_NOT_USE_REASON DO_NOT_USE_REASON , RECORD_RELEASE_TIME RECORD_RELEASE_TIME , SOURCE_CODE SOURCE_CODE    , ADDRESS_LINE1  ADDRESS1,ADDRESS_LINE2  ADDRESS2,CITY  CITY,COL116  ADDRESS3,COL117  ADDRESS4,COL118  COUNTY,COL120  PROVINCE,COL121  CUSTOMER_KEY,COL122  DUNS_NUMBER,COL123  JGZZ_FISCAL_CODE,COL124  REFERENCE_USE_FLAG,COL125  TAX_REFERENCE,COL126  URL,COL127  BEST_TIME_CONTACT_BEGIN,COL128  BEST_TIME_CONTACT_END,COL130  INTERNAL_FLAG,COL132  RENT_OWN_IND,COL133  SALUTATION,COL134  TOTAL_NUM_OF_ORDERS,COL135  TOTAL_ORDERED_AMOUNT,COL136  MAILSTOP,COL137  PERSON_MIDDLE_NAME,COL138  AGE,COL139  DATE_OF_BIRTH,COL140  DATE_OF_DEATH,COL141  DECLARED_ETHNICITY,COL145  HOUSEHOLD_INCOME,COL146  HOUSEHOLD_SIZE,COL147  LAST_ORDERED_DATE,COL148  MARITAL_STATUS,COL149  MARITAL_STATUS_EFFECTIVE_D,COL150  PARTY_NUMBER,COL151  PARTY_SITE_ID,COL152  PARTY_SITE_NAME,COL153  PERSON_NAME,COL154  PERSONAL_INCOME,COL155  PLACE_OF_BIRTH,COL70  GENDER,COL71  LANGUAGE,COL86  HEAD_OF_HOUSEHOLD_FLAG,COUNTRY  COUNTRY,EMAIL_ADDRESS  EMAIL_ADDRESS,FIRST_NAME  PERSON_FIRST_NAME,LAST_NAME  PERSON_LAST_NAME,STATE  STATE,SUFFIX  PERSON_NAME_SUFFIX,TITLE  PERSON_PRE_NAME_ADJUNCT,ZIPCODE  POSTAL_CODE  ,COL1  CONTACT_POINT_ID_S1,COL10  PREFERENCE_CODE_S1,COL11  PHONE_TOUCH_TONE_TYPE_FLAG_S1,COL12  REASON_CODE_S1,COL13  PREFERENCE_START_TIME_HR_S1,COL14  PREFERENCE_END_TIME_HR_S1,COL2  TIME_ZONE_S1,COL4  RAW_PHONE_NUMBER_S1,COL5  PHONE_COUNTRY_CODE_S1,COL6  PHONE_AREA_CODE_S1,COL7  PHONE_EXTENSION_S1,COL8  TELEX_NUMBER_S1,COL9  PHONE_LINE_TYPE_S1,PHONE  PHONE_NUMBER_S1,COL18  CONTACT_POINT_ID_S2,COL19  TIME_ZONE_S2,COL20  PHONE_NUMBER_S2,COL21  RAW_PHONE_NUMBER_S2,COL22  PHONE_COUNTRY_CODE_S2,COL23  PHONE_AREA_CODE_S2,COL24  PHONE_EXTENSION_S2,COL25  TELEX_NUMBER_S2,COL26  PHONE_LINE_TYPE_S2,COL27  PREFERENCE_CODE_S2,COL28  PHONE_TOUCH_TONE_TYPE_FLAG_S2,COL30  PREFERENCE_START_TIME_HR_S2,COL31  PREFERENCE_END_TIME_HR_S2,COL36  REASON_CODE_S2,COL37  CONTACT_POINT_ID_S3,COL38  TIME_ZONE_S3,COL39  PHONE_NUMBER_S3,COL40  RAW_PHONE_NUMBER_S3,COL41  PHONE_COUNTRY_CODE_S3,COL42  PHONE_AREA_CODE_S3,COL43  PHONE_EXTENSION_S3,COL44  TELEX_NUMBER_S3,COL45  PHONE_LINE_TYPE_S3,COL46  PREFERENCE_CODE_S3,COL47  PHONE_TOUCH_TONE_TYPE_FLAG_S3,COL49  PREFERENCE_START_TIME_HR_S3,COL50  PREFERENCE_END_TIME_HR_S3,COL55  REASON_CODE_S3,COL56  CONTACT_POINT_ID_S4,COL57  TIME_ZONE_S4,COL58  PHONE_NUMBER_S4,COL59  RAW_PHONE_NUMBER_S4,COL60  PHONE_COUNTRY_CODE_S4,COL61  PHONE_AREA_CODE_S4,COL62  PHONE_EXTENSION_S4,COL63  TELEX_NUMBER_S4,COL64  PHONE_LINE_TYPE_S4,COL65  PREFERENCE_CODE_S4,COL66  PHONE_TOUCH_TONE_TYPE_FLAG_S4,COL68  PREFERENCE_START_TIME_HR_S4,COL69  PREFERENCE_END_TIME_HR_S4,COL74  REASON_CODE_S4,COL75  CONTACT_POINT_ID_S5,COL76  TIME_ZONE_S5,COL77  PHONE_NUMBER_S5,COL78  RAW_PHONE_NUMBER_S5,COL79  PHONE_COUNTRY_CODE_S5,COL80  PHONE_AREA_CODE_S5,COL81  PHONE_EXTENSION_S5,COL82  TELEX_NUMBER_S5,COL83  PHONE_LINE_TYPE_S5,COL84  PREFERENCE_CODE_S5,COL85  PHONE_TOUCH_TONE_TYPE_FLAG_S5,COL87  PREFERENCE_START_TIME_HR_S5,COL88  PREFERENCE_END_TIME_HR_S5,COL93  REASON_CODE_S5,COL100  PHONE_EXTENSION_S6,COL101  TELEX_NUMBER_S6,COL102  PHONE_LINE_TYPE_S6,COL103  PREFERENCE_CODE_S6,COL104  PHONE_TOUCH_TONE_TYPE_FLAG_S6,COL106  PREFERENCE_START_TIME_HR_S6,COL107  PREFERENCE_END_TIME_HR_S6,COL112  REASON_CODE_S6,COL94  CONTACT_POINT_ID_S6,COL95  TIME_ZONE_S6,COL96  PHONE_NUMBER_S6,COL97  RAW_PHONE_NUMBER_S6,COL98  PHONE_COUNTRY_CODE_S6,COL99  PHONE_AREA_CODE_S6,COL113  FAX_PHONE_AREA_CODE_S7,COL114  FAX_PHONE_COUNTRY_CODE_S7,COL115  TIME_ZONE_S7,FAX  FAX_PHONE_NUMBER_S7  FROM AMS_LIST_ENTRIES WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE = 'PERSON_LIST'

View Text - HTML Formatted

SELECT LIST_ENTRY_ID LIST_ENTRY_ID
, LIST_HEADER_ID LIST_HEADER_ID
, LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID
, SOURCE_CODE_FOR_ID SOURCE_CODE_FOR_ID
, LIST_ENTRY_SOURCE_SYSTEM_ID LIST_ENTRY_SOURCE_SYSTEM_ID
, PARTY_ID PARTY_ID
, CUSTOMER_NAME PARTY_NAME
, CURR_CP_TIME_ZONE CURR_CP_TIME_ZONE
, CURR_CP_ID CURR_CP_ID
, CURR_CP_COUNTRY_CODE CURR_CP_COUNTRY_CODE
, CURR_CP_INDEX CURR_CP_INDEX
, CURR_CP_AREA_CODE CURR_CP_AREA_CODE
, CURR_CP_PHONE_NUMBER CURR_CP_PHONE_NUMBER
, CURR_CP_RAW_PHONE_NUMBER CURR_CP_RAW_PHONE_NUMBER
, NEXT_CALL_TIME NEXT_CALL_TIME
, DO_NOT_USE_FLAG DO_NOT_USE_FLAG
, CALLBACK_FLAG CALLBACK_FLAG
, RECORD_OUT_FLAG RECORD_OUT_FLAG
, ENABLED_FLAG ENABLED_FLAG
, NEWLY_UPDATED_FLAG NEWLY_UPDATED_FLAG
, PIN_CODE PIN_CODE
, CURR_CP_TIME_ZONE_AUX CURR_CP_TIME_ZONE_AUX
, DO_NOT_USE_REASON DO_NOT_USE_REASON
, RECORD_RELEASE_TIME RECORD_RELEASE_TIME
, SOURCE_CODE SOURCE_CODE
, ADDRESS_LINE1 ADDRESS1
, ADDRESS_LINE2 ADDRESS2
, CITY CITY
, COL116 ADDRESS3
, COL117 ADDRESS4
, COL118 COUNTY
, COL120 PROVINCE
, COL121 CUSTOMER_KEY
, COL122 DUNS_NUMBER
, COL123 JGZZ_FISCAL_CODE
, COL124 REFERENCE_USE_FLAG
, COL125 TAX_REFERENCE
, COL126 URL
, COL127 BEST_TIME_CONTACT_BEGIN
, COL128 BEST_TIME_CONTACT_END
, COL130 INTERNAL_FLAG
, COL132 RENT_OWN_IND
, COL133 SALUTATION
, COL134 TOTAL_NUM_OF_ORDERS
, COL135 TOTAL_ORDERED_AMOUNT
, COL136 MAILSTOP
, COL137 PERSON_MIDDLE_NAME
, COL138 AGE
, COL139 DATE_OF_BIRTH
, COL140 DATE_OF_DEATH
, COL141 DECLARED_ETHNICITY
, COL145 HOUSEHOLD_INCOME
, COL146 HOUSEHOLD_SIZE
, COL147 LAST_ORDERED_DATE
, COL148 MARITAL_STATUS
, COL149 MARITAL_STATUS_EFFECTIVE_D
, COL150 PARTY_NUMBER
, COL151 PARTY_SITE_ID
, COL152 PARTY_SITE_NAME
, COL153 PERSON_NAME
, COL154 PERSONAL_INCOME
, COL155 PLACE_OF_BIRTH
, COL70 GENDER
, COL71 LANGUAGE
, COL86 HEAD_OF_HOUSEHOLD_FLAG
, COUNTRY COUNTRY
, EMAIL_ADDRESS EMAIL_ADDRESS
, FIRST_NAME PERSON_FIRST_NAME
, LAST_NAME PERSON_LAST_NAME
, STATE STATE
, SUFFIX PERSON_NAME_SUFFIX
, TITLE PERSON_PRE_NAME_ADJUNCT
, ZIPCODE POSTAL_CODE
, COL1 CONTACT_POINT_ID_S1
, COL10 PREFERENCE_CODE_S1
, COL11 PHONE_TOUCH_TONE_TYPE_FLAG_S1
, COL12 REASON_CODE_S1
, COL13 PREFERENCE_START_TIME_HR_S1
, COL14 PREFERENCE_END_TIME_HR_S1
, COL2 TIME_ZONE_S1
, COL4 RAW_PHONE_NUMBER_S1
, COL5 PHONE_COUNTRY_CODE_S1
, COL6 PHONE_AREA_CODE_S1
, COL7 PHONE_EXTENSION_S1
, COL8 TELEX_NUMBER_S1
, COL9 PHONE_LINE_TYPE_S1
, PHONE PHONE_NUMBER_S1
, COL18 CONTACT_POINT_ID_S2
, COL19 TIME_ZONE_S2
, COL20 PHONE_NUMBER_S2
, COL21 RAW_PHONE_NUMBER_S2
, COL22 PHONE_COUNTRY_CODE_S2
, COL23 PHONE_AREA_CODE_S2
, COL24 PHONE_EXTENSION_S2
, COL25 TELEX_NUMBER_S2
, COL26 PHONE_LINE_TYPE_S2
, COL27 PREFERENCE_CODE_S2
, COL28 PHONE_TOUCH_TONE_TYPE_FLAG_S2
, COL30 PREFERENCE_START_TIME_HR_S2
, COL31 PREFERENCE_END_TIME_HR_S2
, COL36 REASON_CODE_S2
, COL37 CONTACT_POINT_ID_S3
, COL38 TIME_ZONE_S3
, COL39 PHONE_NUMBER_S3
, COL40 RAW_PHONE_NUMBER_S3
, COL41 PHONE_COUNTRY_CODE_S3
, COL42 PHONE_AREA_CODE_S3
, COL43 PHONE_EXTENSION_S3
, COL44 TELEX_NUMBER_S3
, COL45 PHONE_LINE_TYPE_S3
, COL46 PREFERENCE_CODE_S3
, COL47 PHONE_TOUCH_TONE_TYPE_FLAG_S3
, COL49 PREFERENCE_START_TIME_HR_S3
, COL50 PREFERENCE_END_TIME_HR_S3
, COL55 REASON_CODE_S3
, COL56 CONTACT_POINT_ID_S4
, COL57 TIME_ZONE_S4
, COL58 PHONE_NUMBER_S4
, COL59 RAW_PHONE_NUMBER_S4
, COL60 PHONE_COUNTRY_CODE_S4
, COL61 PHONE_AREA_CODE_S4
, COL62 PHONE_EXTENSION_S4
, COL63 TELEX_NUMBER_S4
, COL64 PHONE_LINE_TYPE_S4
, COL65 PREFERENCE_CODE_S4
, COL66 PHONE_TOUCH_TONE_TYPE_FLAG_S4
, COL68 PREFERENCE_START_TIME_HR_S4
, COL69 PREFERENCE_END_TIME_HR_S4
, COL74 REASON_CODE_S4
, COL75 CONTACT_POINT_ID_S5
, COL76 TIME_ZONE_S5
, COL77 PHONE_NUMBER_S5
, COL78 RAW_PHONE_NUMBER_S5
, COL79 PHONE_COUNTRY_CODE_S5
, COL80 PHONE_AREA_CODE_S5
, COL81 PHONE_EXTENSION_S5
, COL82 TELEX_NUMBER_S5
, COL83 PHONE_LINE_TYPE_S5
, COL84 PREFERENCE_CODE_S5
, COL85 PHONE_TOUCH_TONE_TYPE_FLAG_S5
, COL87 PREFERENCE_START_TIME_HR_S5
, COL88 PREFERENCE_END_TIME_HR_S5
, COL93 REASON_CODE_S5
, COL100 PHONE_EXTENSION_S6
, COL101 TELEX_NUMBER_S6
, COL102 PHONE_LINE_TYPE_S6
, COL103 PREFERENCE_CODE_S6
, COL104 PHONE_TOUCH_TONE_TYPE_FLAG_S6
, COL106 PREFERENCE_START_TIME_HR_S6
, COL107 PREFERENCE_END_TIME_HR_S6
, COL112 REASON_CODE_S6
, COL94 CONTACT_POINT_ID_S6
, COL95 TIME_ZONE_S6
, COL96 PHONE_NUMBER_S6
, COL97 RAW_PHONE_NUMBER_S6
, COL98 PHONE_COUNTRY_CODE_S6
, COL99 PHONE_AREA_CODE_S6
, COL113 FAX_PHONE_AREA_CODE_S7
, COL114 FAX_PHONE_COUNTRY_CODE_S7
, COL115 TIME_ZONE_S7
, FAX FAX_PHONE_NUMBER_S7
FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE = 'PERSON_LIST'