eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	MRP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_FULL_PEGGING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PEGGING_ID
MRP_FULL_PEGGING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREV_PEGGING_ID
MRP_FULL_PEGGING_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR DEMAND_ID
MRP_FULL_PEGGING_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR TRANSACTION_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:

MRP: MRP_FULL_PEGGING#