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

VIEW: MRP.MRP_FULL_PEGGING#

Object Details
Object Name: MRP_FULL_PEGGING#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PEGGING_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
COMPILE_DESIGNATOR VARCHAR2 (10) Yes
DEMAND_ID NUMBER

DEMAND_QUANTITY NUMBER

TRANSACTION_ID NUMBER

SUPPLY_QUANTITY NUMBER

ALLOCATED_QUANTITY NUMBER

PREV_PEGGING_ID NUMBER

DEMAND_CLASS VARCHAR2 (40)
UPDATED NUMBER

STATUS NUMBER

END_ITEM_USAGE NUMBER

END_PEGGING_ID NUMBER

DEMAND_DATE DATE

SUPPLY_DATE DATE

SUPPLY_TYPE NUMBER

DISPOSITION_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
END_ORIGINATION_TYPE NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
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# references the following:

SchemaMRP
TableMRP_FULL_PEGGING
MRP.MRP_FULL_PEGGING# is referenced by following:

SchemaAPPS
SynonymMRP_FULL_PEGGING