DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_PRODUCT_MAPPING_V

Object Details
Object Name: AMS_PRODUCT_MAPPING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PRODUCT_MAPPING_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.AMS_PRODUCT_MAPPING_V references the following:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
SynonymAMS_IMP_SOURCE_LINES

APPS.AMS_PRODUCT_MAPPING_V is not referenced by any database object