[Home] [Help] [Dependency Information]
Object Name: | MRP_ITEM_SUPPLIERS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_ITEM_SUPPLIERS |
Subobject Name: | |
Status: | VALID |
MRP_ITEM_SUPPLIERS stores information on the suppliers of planned items within an MPS, MRP, or DRP plan. Each row stores the processing lead time, order modifiers and the delivery calendar code of a specific source for an item.
This table is populated by the Memory-based Snapshot with the information being obtained from the PO_ASL_ATTRIBUTES table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_ITEM_SUPPLIERS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
SUPPLIER_ID SUPPLIER_SITE_ID ORGANIZATION_ID INVENTORY_ITEM_ID USING_ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
SUPPLIER_ID | NUMBER | Yes | Source supplier | |
SUPPLIER_SITE_ID | NUMBER | Yes | Source supplier site | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
USING_ORGANIZATION_ID | NUMBER | Yes | Using Organization Id | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
PROCESSING_LEAD_TIME | NUMBER | Supplier processing lead time | ||
MINIMUM_ORDER_QUANTITY | NUMBER | Minimum order quantity for the item | ||
FIXED_LOT_MULTIPLIER | NUMBER | Fixed lot multiplier | ||
DELIVERY_CALENDAR_CODE | VARCHAR2 | (10) | Delivery/reception calendar of source | |
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 | ||
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 | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT COMPILE_DESIGNATOR
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, ORGANIZATION_ID
, USING_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PROCESSING_LEAD_TIME
, MINIMUM_ORDER_QUANTITY
, FIXED_LOT_MULTIPLIER
, DELIVERY_CALENDAR_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MRP.MRP_ITEM_SUPPLIERS;
MRP.MRP_ITEM_SUPPLIERS does not reference any database object
MRP.MRP_ITEM_SUPPLIERS is referenced by following:
|
|
|