VIEW: APPS.AMS_TAR_ORGANIZATION_CONTACT_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,COL119  TITLE,COL120  PROVINCE,COL121  CUSTOMER_KEY,COL122  DUNS_NUMBER,COL123  JGZZ_FISCAL_CODE,COL124  REFERENCE_USE_FLAG,COL125  TAX_REFERENCE,COL126  URL,COL131  ORIG_SYSTEM_REFERENCE,COL136  MAIL_STOP,COL137  PERSON_MIDDLE_NAME,COL138  DEPARTMENT,COL139  CONTACT_ID,COL140  PARTY_CONTACT_NAME,COL141  CONTACT_NUMBER,COL142  DECISION_MAKER_FLAG,COL143  DEPARTMENT_CODE,COL144  JOB_TITLE,COL145  JOB_TITLE_CODE,COL146  MANAGED_BY,COL147  ORGANIZATION_ID,COL148  PERSON_ACADEMIC_TITLE,COL149  PERSON_IDEN_TYPE,COL150  PERSON_IDENTIFIER,COL151  PARTY_SITE_ID,COL152  PERSON_PREVIOUS_LAST_NAME,COL153  RANK,COL154  GROUP_TYPE,COL156  HQ_BRANCH_IND,COL157  KNOWN_AS,COL158  SIC_CODE,COL159  SIC_CODE_TYPE,COL160  STATUS,COL161  TAX_NAME,COL162  VALIDATED_FLAG,COL278  ROLE_TYPE,COL279  RELATIONSHIP_CODE,COL70  GENDER,COL71  NATIVE_LANGUAGE,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,COL218  UNDER_SHIPMENT_TOLERANCE_S7,COL113  FAX_PHONE_AREA_CODE_S8,COL114  FAX_PHONE_COUNTRY_CODE_S8,COL115  TIME_ZONE_S8,FAX  FAX_PHONE_NUMBER_S8,COL121  CUSTOMER_KEY_S9,COL126  URL_S9,COL134  TOTAL_NUM_OF_ORDERS_S9,COL135  TOTAL_ORDERED_AMOUNT_S9,COL284  PARTY_ID_S9,COL298  ORGANIZATION_NAME_S9,COL258  SIC_CODE_S10,COL260  FISCAL_YEAREND_MONTH_S10,COL261  EMPLOYEES_TOTAL_S10,COL262  CURR_FY_POTENTIAL_REVENUE_S10  FROM AMS_LIST_ENTRIES WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE = 'ORGANIZATION_CONTACT_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
, COL119 TITLE
, COL120 PROVINCE
, COL121 CUSTOMER_KEY
, COL122 DUNS_NUMBER
, COL123 JGZZ_FISCAL_CODE
, COL124 REFERENCE_USE_FLAG
, COL125 TAX_REFERENCE
, COL126 URL
, COL131 ORIG_SYSTEM_REFERENCE
, COL136 MAIL_STOP
, COL137 PERSON_MIDDLE_NAME
, COL138 DEPARTMENT
, COL139 CONTACT_ID
, COL140 PARTY_CONTACT_NAME
, COL141 CONTACT_NUMBER
, COL142 DECISION_MAKER_FLAG
, COL143 DEPARTMENT_CODE
, COL144 JOB_TITLE
, COL145 JOB_TITLE_CODE
, COL146 MANAGED_BY
, COL147 ORGANIZATION_ID
, COL148 PERSON_ACADEMIC_TITLE
, COL149 PERSON_IDEN_TYPE
, COL150 PERSON_IDENTIFIER
, COL151 PARTY_SITE_ID
, COL152 PERSON_PREVIOUS_LAST_NAME
, COL153 RANK
, COL154 GROUP_TYPE
, COL156 HQ_BRANCH_IND
, COL157 KNOWN_AS
, COL158 SIC_CODE
, COL159 SIC_CODE_TYPE
, COL160 STATUS
, COL161 TAX_NAME
, COL162 VALIDATED_FLAG
, COL278 ROLE_TYPE
, COL279 RELATIONSHIP_CODE
, COL70 GENDER
, COL71 NATIVE_LANGUAGE
, 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
, COL218 UNDER_SHIPMENT_TOLERANCE_S7
, COL113 FAX_PHONE_AREA_CODE_S8
, COL114 FAX_PHONE_COUNTRY_CODE_S8
, COL115 TIME_ZONE_S8
, FAX FAX_PHONE_NUMBER_S8
, COL121 CUSTOMER_KEY_S9
, COL126 URL_S9
, COL134 TOTAL_NUM_OF_ORDERS_S9
, COL135 TOTAL_ORDERED_AMOUNT_S9
, COL284 PARTY_ID_S9
, COL298 ORGANIZATION_NAME_S9
, COL258 SIC_CODE_S10
, COL260 FISCAL_YEAREND_MONTH_S10
, COL261 EMPLOYEES_TOTAL_S10
, COL262 CURR_FY_POTENTIAL_REVENUE_S10
FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE = 'ORGANIZATION_CONTACT_LIST'