APPS.AMS_PRODUCT_MAPPING_V
[Home] [Help]
| Product: | AMS - Marketing |
|---|---|
| Description: | Product view for import. |
| Implementation/DBA Data: |
APPS.AMS_PRODUCT_MAPPING_V
|
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'