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

TABLE: MSC.MSC_ITEM_CUSTOMERS

Object Details
Object Name: MSC_ITEM_CUSTOMERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ITEM_CUSTOMERS
Subobject Name:
Status: VALID


This table contains the list of customer items and cross references used in Oracle Advanced planning and scheduling. This table is used in Oracle Collaborative planning functionality
to allow loading transaction data using item names and descriptions as seen by the
customer. Similar to the approved supplier list contained in MSC_ITEM_SUPPLIER S table,
records in MSC_ITEM_CUSTOMERS point to master items contained in the msc_items
table.
The inventory_item_id column corresponds to the item_id column in MSC_ITEMS.
The customer_item_name contains the name for that item used by the
customer.
This table is populated by the Collections program from the Oracle ERP system
or by the flat file/XML loads for data downloaded from Legacy systems.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
CUSTOMER_ID NUMBER
Yes Customer identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SR_INSTANCE_ID NUMBER

Source application instance identifier
CUSTOMER_ITEM_NAME VARCHAR2 (255)
Customer item name
DESCRIPTION VARCHAR2 (240)
Description
LEAD_TIME NUMBER

Lead time
UOM_CODE VARCHAR2 (3)
Unit of measure code
LIST_PRICE NUMBER

List price
PLANNER_CODE VARCHAR2 (10)
Planner code
REFRESH_NUMBER NUMBER

Refresh number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who Column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who Column
PROGRAM_ID NUMBER

Concurrent Who Column
PROGRAM_UPDATE_DATE DATE

Concurrent Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      CUSTOMER_ITEM_NAME
,      DESCRIPTION
,      LEAD_TIME
,      UOM_CODE
,      LIST_PRICE
,      PLANNER_CODE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM MSC.MSC_ITEM_CUSTOMERS;

Dependencies

[top of page]

MSC.MSC_ITEM_CUSTOMERS does not reference any database object

MSC.MSC_ITEM_CUSTOMERS is referenced by following:

SchemaMSC
ViewMSC_ITEM_CUSTOMERS#