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

VIEW: APPS.MRPBV_PLAN_PEGS

Object Details
Object Name: MRPBV_PLAN_PEGS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPBV_PLAN_PEGS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows the full pegging information for every order.
Each row represents the allocation of a supply order to an end demand.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_QUANTITY NUMBER

SUPPLY_QUANTITY NUMBER

SUPPLY_ALLOCATED_QUANTITY NUMBER

DEMAND_DATE DATE

SUPPLY_DATE DATE

SUPPLY_TYPE VARCHAR2 (80)
DEMAND_TYPE_OF_END_DEMAND VARCHAR2 (80)
END_ITEM_USAGE NUMBER

PEGGING_ID NUMBER
Yes
PREV_PEGGING_ID NUMBER

END_PEGGING_ID NUMBER

ORGANIZATION_ID NUMBER
Yes
PLAN_NAME VARCHAR2 (10) Yes
INVENTORY_ITEM_ID NUMBER
Yes
PLAN_SUPPLY_ID NUMBER

PLAN_DEMAND_ID NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

User identifier who last updated the row
CREATION_DATE DATE

CREATED_BY NUMBER

Query Text

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


SELECT DEMAND_QUANTITY
,      SUPPLY_QUANTITY
,      SUPPLY_ALLOCATED_QUANTITY
,      DEMAND_DATE
,      SUPPLY_DATE
,      SUPPLY_TYPE
,      DEMAND_TYPE_OF_END_DEMAND
,      END_ITEM_USAGE
,      PEGGING_ID
,      PREV_PEGGING_ID
,      END_PEGGING_ID
,      ORGANIZATION_ID
,      PLAN_NAME
,      INVENTORY_ITEM_ID
,      PLAN_SUPPLY_ID
,      PLAN_DEMAND_ID
,      PROJECT_ID
,      TASK_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPBV_PLAN_PEGS;

Dependencies

[top of page]

APPS.MRPBV_PLAN_PEGS references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_FULL_PEGGING

APPS.MRPBV_PLAN_PEGS is not referenced by any database object