VIEW: APPS.AMS_PRODUCT_MAPPING_V

Source

View Text - Preformatted

SELECT line.IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID, line.LAST_UPDATE_DATE LAST_UPDATE_DATE, line.LAST_UPDATED_BY LAST_UPDATED_BY, line.CREATION_DATE CREATION_DATE, line.CREATED_BY CREATED_BY, line.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, line.IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID, line.IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG, line.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, line.LOAD_STATUS LOAD_STATUS, COL1 ORGANIZATION_NAME, COL2 ITEM_NUMBER, COL3 DESCRIPTION, COL241 LONG_DESCRIPTION, COL4 ITEM_TYPE, COL5 PRIMARY_UOM_CODE, COL6 INVENTORY_ITEM_STATUS_CODE, COL7 INVENTORY_ITEM_FLAG, COL8 STOCK_ENABLED_FLAG, COL9 MTL_TRANSACTIONS_ENABLED_FLAG, COL10 REVISION_QTY_CONTROL_CODE , COL11 BOM_ENABLED_FLAG, COL12 COSTING_ENABLED_FLAG, COL13 ELECTRONIC_FLAG, COL14 DOWNLOADABLE_FLAG, COL15 CUSTOMER_ORDER_FLAG, COL16 CUSTOMER_ORDER_ENABLED_FLAG, COL17 INTERNAL_ORDER_FLAG, COL18 INTERNAL_ORDER_ENABLED_FLAG, COL19 SHIPPABLE_ITEM_FLAG , COL20 RETURNABLE_FLAG, COL21 COMMS_ACTIVATION_REQD_FLAG, COL22 REPLENISH_TO_ORDER_FLAG , COL23 INVOICEABLE_ITEM_FLAG , COL24 INVOICE_ENABLED_FLAG , COL25 SERVICE_ITEM_FLAG , COL26 SERVICEABLE_PRODUCT_FLAG, COL27 VENDOR_WARRANTY_FLAG, COL28 COVERAGE_SCHEDULE, COL29 SERVICE_DURATION, COL30 SERVICE_DURATION_PERIOD_CODE, COL31 DEFECT_TRACKING_ON_FLAG , COL32 ORDERABLE_ON_WEB_FLAG, COL33 BACK_ORDERABLE_FLAG, COL34 COLLATERAL_FLAG, COL35 WEIGHT_UOM_CODE, COL36 UNIT_WEIGHT, COL37 EVENT_FLAG, COL38 COMMS_NL_TRACKABLE_FLAG, COL39 PRICE_LIST_NAME, COL40 LIST_PRICE, COL41 PRODUCT_UOM_CODE, COL42 CATEGORY_SET_NAME, COL43 CATEGORY_CODE, COL44 CONTENT_ACCESS_NAME, COL45 MEDIA_OBJECT, COL48 SECTION_CODE , COL49 STORE_CODE, COL50 TEMPLATE_ACCESS_NAME, COL51 LANGUAGE, COL52 BOM_ITEM_TYPE, COL53 PICK_COMPONENTS_FLAG, COL54 WEB_STATUS, COL55 COMP_PROD_NAME, COL56 COMP_PROD_CODE, COL57 COMP_URL, COL58 COMP_PARTY_NAME, COL59 PRICE_LIST_CURRENCY, line.batch_id batch_id, COL242 AMS_COL201 , COL242 AMS_COL202 , COL242 AMS_COL203 , COL242 AMS_COL204 , COL242 AMS_COL205 , COL242 AMS_COL206 , COL242 AMS_COL207 , COL242 AMS_COL208 , COL242 AMS_COL209 , COL242 AMS_COL210 , COL242 AMS_COL211 , COL242 AMS_COL212 , COL242 AMS_COL213 , COL242 AMS_COL214 , COL242 AMS_COL215 , COL242 AMS_COL216 , COL242 AMS_COL217 , COL242 AMS_COL218 , COL242 AMS_COL219 , COL242 AMS_COL220 , COL242 AMS_COL221 , COL242 AMS_COL222 , COL242 AMS_COL223 , COL242 AMS_COL224 , COL242 AMS_COL225 , COL242 AMS_COL226 , COL242 AMS_COL227 , COL242 AMS_COL228 , COL242 AMS_COL229 , COL242 AMS_COL230 , COL242 AMS_COL231 , COL242 AMS_COL232 , COL242 AMS_COL233 , COL242 AMS_COL234 , COL242 AMS_COL235 , COL242 AMS_COL236 , COL242 AMS_COL237 , COL242 AMS_COL238 , COL242 AMS_COL239 , COL242 AMS_COL240 , COL242 AMS_COL241 , COL242 AMS_COL242 , COL242 AMS_COL243 , COL242 AMS_COL244 , COL242 AMS_COL245 , COL242 AMS_COL246 , COL242 AMS_COL247 , COL242 AMS_COL248 , COL242 AMS_COL249 , COL242 AMS_COL250, COL242 AMS_COL251, COL242 AMS_COL252, COL242 AMS_COL253, COL242 AMS_COL254, COL242 AMS_COL255, COL242 AMS_COL256, COL242 AMS_COL257, COL242 AMS_COL258, COL242 AMS_COL259, COL242 AMS_COL260, COL242 AMS_COL261, COL242 AMS_COL262, COL242 AMS_COL263, COL242 AMS_COL264, COL242 AMS_COL265, COL242 AMS_COL266 FROM AMS_IMP_SOURCE_LINES line, ams_imp_list_headers_all header WHERE LINE.import_list_header_id = header.import_list_header_id and header.import_type = 'PRODUCT'

View Text - HTML Formatted

SELECT LINE.IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID
, LINE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY LAST_UPDATED_BY
, LINE.CREATION_DATE CREATION_DATE
, LINE.CREATED_BY CREATED_BY
, LINE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINE.IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_ID
, LINE.IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG
, LINE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LINE.LOAD_STATUS LOAD_STATUS
, COL1 ORGANIZATION_NAME
, COL2 ITEM_NUMBER
, COL3 DESCRIPTION
, COL241 LONG_DESCRIPTION
, COL4 ITEM_TYPE
, COL5 PRIMARY_UOM_CODE
, COL6 INVENTORY_ITEM_STATUS_CODE
, COL7 INVENTORY_ITEM_FLAG
, COL8 STOCK_ENABLED_FLAG
, COL9 MTL_TRANSACTIONS_ENABLED_FLAG
, COL10 REVISION_QTY_CONTROL_CODE
, COL11 BOM_ENABLED_FLAG
, COL12 COSTING_ENABLED_FLAG
, COL13 ELECTRONIC_FLAG
, COL14 DOWNLOADABLE_FLAG
, COL15 CUSTOMER_ORDER_FLAG
, COL16 CUSTOMER_ORDER_ENABLED_FLAG
, COL17 INTERNAL_ORDER_FLAG
, COL18 INTERNAL_ORDER_ENABLED_FLAG
, COL19 SHIPPABLE_ITEM_FLAG
, COL20 RETURNABLE_FLAG
, COL21 COMMS_ACTIVATION_REQD_FLAG
, COL22 REPLENISH_TO_ORDER_FLAG
, COL23 INVOICEABLE_ITEM_FLAG
, COL24 INVOICE_ENABLED_FLAG
, COL25 SERVICE_ITEM_FLAG
, COL26 SERVICEABLE_PRODUCT_FLAG
, COL27 VENDOR_WARRANTY_FLAG
, COL28 COVERAGE_SCHEDULE
, COL29 SERVICE_DURATION
, COL30 SERVICE_DURATION_PERIOD_CODE
, COL31 DEFECT_TRACKING_ON_FLAG
, COL32 ORDERABLE_ON_WEB_FLAG
, COL33 BACK_ORDERABLE_FLAG
, COL34 COLLATERAL_FLAG
, COL35 WEIGHT_UOM_CODE
, COL36 UNIT_WEIGHT
, COL37 EVENT_FLAG
, COL38 COMMS_NL_TRACKABLE_FLAG
, COL39 PRICE_LIST_NAME
, COL40 LIST_PRICE
, COL41 PRODUCT_UOM_CODE
, COL42 CATEGORY_SET_NAME
, COL43 CATEGORY_CODE
, COL44 CONTENT_ACCESS_NAME
, COL45 MEDIA_OBJECT
, COL48 SECTION_CODE
, COL49 STORE_CODE
, COL50 TEMPLATE_ACCESS_NAME
, COL51 LANGUAGE
, COL52 BOM_ITEM_TYPE
, COL53 PICK_COMPONENTS_FLAG
, COL54 WEB_STATUS
, COL55 COMP_PROD_NAME
, COL56 COMP_PROD_CODE
, COL57 COMP_URL
, COL58 COMP_PARTY_NAME
, COL59 PRICE_LIST_CURRENCY
, LINE.BATCH_ID BATCH_ID
, COL242 AMS_COL201
, COL242 AMS_COL202
, COL242 AMS_COL203
, COL242 AMS_COL204
, COL242 AMS_COL205
, COL242 AMS_COL206
, COL242 AMS_COL207
, COL242 AMS_COL208
, COL242 AMS_COL209
, COL242 AMS_COL210
, COL242 AMS_COL211
, COL242 AMS_COL212
, COL242 AMS_COL213
, COL242 AMS_COL214
, COL242 AMS_COL215
, COL242 AMS_COL216
, COL242 AMS_COL217
, COL242 AMS_COL218
, COL242 AMS_COL219
, COL242 AMS_COL220
, COL242 AMS_COL221
, COL242 AMS_COL222
, COL242 AMS_COL223
, COL242 AMS_COL224
, COL242 AMS_COL225
, COL242 AMS_COL226
, COL242 AMS_COL227
, COL242 AMS_COL228
, COL242 AMS_COL229
, COL242 AMS_COL230
, COL242 AMS_COL231
, COL242 AMS_COL232
, COL242 AMS_COL233
, COL242 AMS_COL234
, COL242 AMS_COL235
, COL242 AMS_COL236
, COL242 AMS_COL237
, COL242 AMS_COL238
, COL242 AMS_COL239
, COL242 AMS_COL240
, COL242 AMS_COL241
, COL242 AMS_COL242
, COL242 AMS_COL243
, COL242 AMS_COL244
, COL242 AMS_COL245
, COL242 AMS_COL246
, COL242 AMS_COL247
, COL242 AMS_COL248
, COL242 AMS_COL249
, COL242 AMS_COL250
, COL242 AMS_COL251
, COL242 AMS_COL252
, COL242 AMS_COL253
, COL242 AMS_COL254
, COL242 AMS_COL255
, COL242 AMS_COL256
, COL242 AMS_COL257
, COL242 AMS_COL258
, COL242 AMS_COL259
, COL242 AMS_COL260
, COL242 AMS_COL261
, COL242 AMS_COL262
, COL242 AMS_COL263
, COL242 AMS_COL264
, COL242 AMS_COL265
, COL242 AMS_COL266
FROM AMS_IMP_SOURCE_LINES LINE
, AMS_IMP_LIST_HEADERS_ALL HEADER
WHERE LINE.IMPORT_LIST_HEADER_ID = HEADER.IMPORT_LIST_HEADER_ID
AND HEADER.IMPORT_TYPE = 'PRODUCT'