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


TABLE: MRP.MRP_FULL_PEGGING

Object Details
Object Name: MRP_FULL_PEGGING
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_FULL_PEGGING
Subobject Name:
Status: VALID


MRP_FULL_PEGGING stores the full pegging information for every supply
order. Each row represents the allocation of a supply order to an end
demand. This information is calculated for each item where pegging is
set to Full Pegging and for Plans that have full pegging option set to
Yes.
.
This table is populated by the Memory-based Planner and is used by the
Planner Workbench to display full pegging.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_FULL_PEGGING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPEGGING_ID
MRP_FULL_PEGGING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREV_PEGGING_ID
MRP_FULL_PEGGING_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnDEMAND_ID
MRP_FULL_PEGGING_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
PEGGING_ID NUMBER
Yes Unique identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
DEMAND_ID NUMBER

Demand identifier
DEMAND_QUANTITY NUMBER

Demand quantity
TRANSACTION_ID NUMBER

Supply identifier
SUPPLY_QUANTITY NUMBER

Supply quantity
ALLOCATED_QUANTITY NUMBER

Portion of supply allocated to demand
PREV_PEGGING_ID NUMBER

Reference to previous level's pegging identifier
DEMAND_CLASS VARCHAR2 (40)
Not currently used
UPDATED NUMBER

Flag to determine whether add workday modification was applied
STATUS NUMBER

Attribute used for online replanning
END_ITEM_USAGE NUMBER

Usage of current item in end assembly
END_PEGGING_ID NUMBER

End pegging node identifier
DEMAND_DATE DATE

Demand date
SUPPLY_DATE DATE

Supply date
SUPPLY_TYPE NUMBER

Supply type identifier
DISPOSITION_ID NUMBER

Disposition identifier
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
END_ORIGINATION_TYPE NUMBER

Origination type of the end demand
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item unit number
Query Text

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


SELECT PEGGING_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      DEMAND_ID
,      DEMAND_QUANTITY
,      TRANSACTION_ID
,      SUPPLY_QUANTITY
,      ALLOCATED_QUANTITY
,      PREV_PEGGING_ID
,      DEMAND_CLASS
,      UPDATED
,      STATUS
,      END_ITEM_USAGE
,      END_PEGGING_ID
,      DEMAND_DATE
,      SUPPLY_DATE
,      SUPPLY_TYPE
,      DISPOSITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_ID
,      TASK_ID
,      END_ORIGINATION_TYPE
,      END_ITEM_UNIT_NUMBER
FROM MRP.MRP_FULL_PEGGING;

Dependencies

[top of page]

MRP.MRP_FULL_PEGGING does not reference any database object

MRP.MRP_FULL_PEGGING is referenced by following:

SchemaAPPS
SynonymMRP_FULL_PEGGING