[Home] [Help] [Dependency Information]
Object Name: | AMS_PRODUCT_MAPPING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_PRODUCT_MAPPING_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMPORT_SOURCE_LINE_ID | NUMBER | Yes | Unique Identifier. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard WHO Column |
IMPORT_LIST_HEADER_ID | NUMBER | Yes | Reference key to the corresponding import header. | |
IMPORT_SUCCESSFUL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the record was successfully processed through business rules. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
LOAD_STATUS | VARCHAR2 | (30) | Result of the import . | |
ORGANIZATION_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
ITEM_NUMBER | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
DESCRIPTION | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
LONG_DESCRIPTION | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
ITEM_TYPE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
PRIMARY_UOM_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INVENTORY_ITEM_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
STOCK_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
REVISION_QTY_CONTROL_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
BOM_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COSTING_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
ELECTRONIC_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
DOWNLOADABLE_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
CUSTOMER_ORDER_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INTERNAL_ORDER_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SHIPPABLE_ITEM_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
RETURNABLE_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMMS_ACTIVATION_REQD_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INVOICEABLE_ITEM_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
INVOICE_ENABLED_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SERVICE_ITEM_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
VENDOR_WARRANTY_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COVERAGE_SCHEDULE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SERVICE_DURATION | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
DEFECT_TRACKING_ON_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
ORDERABLE_ON_WEB_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
BACK_ORDERABLE_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COLLATERAL_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
WEIGHT_UOM_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
UNIT_WEIGHT | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
EVENT_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
PRICE_LIST_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
LIST_PRICE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
PRODUCT_UOM_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
CATEGORY_SET_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
CATEGORY_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
CONTENT_ACCESS_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
MEDIA_OBJECT | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
SECTION_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
STORE_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
TEMPLATE_ACCESS_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
LANGUAGE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
BOM_ITEM_TYPE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
PICK_COMPONENTS_FLAG | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
WEB_STATUS | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMP_PROD_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMP_PROD_CODE | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMP_URL | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
COMP_PARTY_NAME | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
PRICE_LIST_CURRENCY | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 150 characters. | |
BATCH_ID | NUMBER | Stores the batch_id for this column. | ||
AMS_COL201 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL202 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL203 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL204 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL205 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL206 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL207 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL208 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL209 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL210 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL211 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL212 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL213 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL214 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL215 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL216 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL217 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL218 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL219 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL220 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL221 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL222 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL223 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL224 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL225 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL226 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL227 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL228 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL229 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL230 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL231 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL232 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL233 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL234 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL235 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL236 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL237 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL238 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL239 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL240 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL241 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL242 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL243 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL244 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL245 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL246 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL247 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL248 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL249 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL250 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL251 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL252 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL253 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL254 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL255 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL256 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL257 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL258 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL259 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL260 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL261 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL262 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL263 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL264 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL265 | VARCHAR2 | (4000) | Column used for not mapped column in list import. | |
AMS_COL266 | VARCHAR2 | (4000) | Column used for not mapped column in list import. |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORT_SOURCE_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IMPORT_LIST_HEADER_ID
, IMPORT_SUCCESSFUL_FLAG
, OBJECT_VERSION_NUMBER
, LOAD_STATUS
, ORGANIZATION_NAME
, ITEM_NUMBER
, DESCRIPTION
, LONG_DESCRIPTION
, ITEM_TYPE
, PRIMARY_UOM_CODE
, INVENTORY_ITEM_STATUS_CODE
, INVENTORY_ITEM_FLAG
, STOCK_ENABLED_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG
, REVISION_QTY_CONTROL_CODE
, BOM_ENABLED_FLAG
, COSTING_ENABLED_FLAG
, ELECTRONIC_FLAG
, DOWNLOADABLE_FLAG
, CUSTOMER_ORDER_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, INTERNAL_ORDER_FLAG
, INTERNAL_ORDER_ENABLED_FLAG
, SHIPPABLE_ITEM_FLAG
, RETURNABLE_FLAG
, COMMS_ACTIVATION_REQD_FLAG
, REPLENISH_TO_ORDER_FLAG
, INVOICEABLE_ITEM_FLAG
, INVOICE_ENABLED_FLAG
, SERVICE_ITEM_FLAG
, SERVICEABLE_PRODUCT_FLAG
, VENDOR_WARRANTY_FLAG
, COVERAGE_SCHEDULE
, SERVICE_DURATION
, SERVICE_DURATION_PERIOD_CODE
, DEFECT_TRACKING_ON_FLAG
, ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG
, COLLATERAL_FLAG
, WEIGHT_UOM_CODE
, UNIT_WEIGHT
, EVENT_FLAG
, COMMS_NL_TRACKABLE_FLAG
, PRICE_LIST_NAME
, LIST_PRICE
, PRODUCT_UOM_CODE
, CATEGORY_SET_NAME
, CATEGORY_CODE
, CONTENT_ACCESS_NAME
, MEDIA_OBJECT
, SECTION_CODE
, STORE_CODE
, TEMPLATE_ACCESS_NAME
, LANGUAGE
, BOM_ITEM_TYPE
, PICK_COMPONENTS_FLAG
, WEB_STATUS
, COMP_PROD_NAME
, COMP_PROD_CODE
, COMP_URL
, COMP_PARTY_NAME
, PRICE_LIST_CURRENCY
, BATCH_ID
, AMS_COL201
, AMS_COL202
, AMS_COL203
, AMS_COL204
, AMS_COL205
, AMS_COL206
, AMS_COL207
, AMS_COL208
, AMS_COL209
, AMS_COL210
, AMS_COL211
, AMS_COL212
, AMS_COL213
, AMS_COL214
, AMS_COL215
, AMS_COL216
, AMS_COL217
, AMS_COL218
, AMS_COL219
, AMS_COL220
, AMS_COL221
, AMS_COL222
, AMS_COL223
, AMS_COL224
, AMS_COL225
, AMS_COL226
, AMS_COL227
, AMS_COL228
, AMS_COL229
, AMS_COL230
, AMS_COL231
, AMS_COL232
, AMS_COL233
, AMS_COL234
, AMS_COL235
, AMS_COL236
, AMS_COL237
, AMS_COL238
, AMS_COL239
, AMS_COL240
, AMS_COL241
, AMS_COL242
, AMS_COL243
, AMS_COL244
, AMS_COL245
, AMS_COL246
, AMS_COL247
, AMS_COL248
, AMS_COL249
, AMS_COL250
, AMS_COL251
, AMS_COL252
, AMS_COL253
, AMS_COL254
, AMS_COL255
, AMS_COL256
, AMS_COL257
, AMS_COL258
, AMS_COL259
, AMS_COL260
, AMS_COL261
, AMS_COL262
, AMS_COL263
, AMS_COL264
, AMS_COL265
, AMS_COL266
FROM APPS.AMS_PRODUCT_MAPPING_V;
APPS.AMS_PRODUCT_MAPPING_V is not referenced by any database object
|
|
|