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: MSC.MSC_FULL_PEGGING

Object Details

Object Name:	MSC_FULL_PEGGING
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_FULL_PEGGING
Subobject Name:
Status:	VALID

This table represents the pegging from supply to demands.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
MSC_FULL_PEGGING_U1	NORMAL	UNIQUE	PLAN_ID PEGGING_ID SR_INSTANCE_ID
MSC_FULL_PEGGING_N1	NORMAL	NONUNIQUE	PLAN_ID PREV_PEGGING_ID SR_INSTANCE_ID
MSC_FULL_PEGGING_N2	NORMAL	NONUNIQUE	PLAN_ID DEMAND_ID SR_INSTANCE_ID ORGANIZATION_ID
MSC_FULL_PEGGING_N3	NORMAL	NONUNIQUE	PLAN_ID TRANSACTION_ID SR_INSTANCE_ID ORGANIZATION_ID
MSC_FULL_PEGGING_N4	NORMAL	NONUNIQUE	PLAN_ID END_PEGGING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PEGGING_ID	NUMBER		Yes	Pegging identifier
DEMAND_QUANTITY	NUMBER			Demand quantity
SUPPLY_QUANTITY	NUMBER			Supply quantity
ALLOCATED_QUANTITY	NUMBER			Portion of supply allocated to demand
END_ITEM_USAGE	NUMBER			Usage of current item in end assembly
DEMAND_DATE	DATE			Demand date
SUPPLY_DATE	DATE			Supply date
SUPPLY_TYPE	NUMBER			Supply type identifier
END_ORIGINATION_TYPE	NUMBER			Origination type of the end demand
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
PLAN_ID	NUMBER		Yes	Plan identifier
PREV_PEGGING_ID	NUMBER			Reference to previous level's pegging identifier
END_PEGGING_ID	NUMBER			Reference to end pegging node identifier
TRANSACTION_ID	NUMBER			Supply identifier
DISPOSITION_ID	NUMBER			Disposition identifier
DEMAND_ID	NUMBER			Demand identifier
PROJECT_ID	NUMBER			Project identifier
TASK_ID	NUMBER			Task identifier
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
DEMAND_CLASS	VARCHAR2	(34)		Demand class code
UPDATED	NUMBER			Flag to determine whether add workday modification was applied
STATUS	NUMBER			Attribute used for online replanning
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
UNIT_NUMBER	VARCHAR2	(30)		Unit number
DEST_TRANSACTION_ID	NUMBER

Query Text

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


SELECT PEGGING_ID
,      DEMAND_QUANTITY
,      SUPPLY_QUANTITY
,      ALLOCATED_QUANTITY
,      END_ITEM_USAGE
,      DEMAND_DATE
,      SUPPLY_DATE
,      SUPPLY_TYPE
,      END_ORIGINATION_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PLAN_ID
,      PREV_PEGGING_ID
,      END_PEGGING_ID
,      TRANSACTION_ID
,      DISPOSITION_ID
,      DEMAND_ID
,      PROJECT_ID
,      TASK_ID
,      SR_INSTANCE_ID
,      DEMAND_CLASS
,      UPDATED
,      STATUS
,      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
,      UNIT_NUMBER
,      DEST_TRANSACTION_ID
FROM MSC.MSC_FULL_PEGGING;

Dependencies

[top of page]

MSC.MSC_FULL_PEGGING does not reference any database object

MSC.MSC_FULL_PEGGING is referenced by following:

MSC: MSC_FULL_PEGGING#