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


VIEW: APPS.MRP_FLP_DEMAND_SUPPLY_V2

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
COMPILE_DESIGNATOR VARCHAR2 (10)
ORGANIZATION_ID NUMBER

PEGGING_ID NUMBER

PREV_PEGGING_ID NUMBER

DEMAND_ID NUMBER

TRANSACTION_ID NUMBER

END_ITEM_USAGE NUMBER

INVENTORY_ITEM_ID NUMBER

ITEM_ORG VARCHAR2 (44)
SUPPLY_QTY NUMBER

PEGGED_QTY NUMBER

SUPPLY_DATE DATE

DEMAND_QTY NUMBER

DEMAND_DATE DATE

ORDER_NAME VARCHAR2 (80)
PROJECT_NUMBER VARCHAR2 (4000)
TASK_NUMBER VARCHAR2 (4000)
ORDER_TYPE NUMBER

DISPOSITION VARCHAR2 (240)
END_PEGGED_QTY NUMBER

END_DEMAND_QTY NUMBER

END_DEMAND_DATE DATE

END_ITEM_ORG VARCHAR2 (44)
END_ITEM_DESC VARCHAR2 (20)
END_ORIGINATION_NAME VARCHAR2 (80)
END_DISPOSITION VARCHAR2 (240)
END_PROJECT_NUMBER VARCHAR2 (4000)
END_TASK_NUMBER VARCHAR2 (4000)
END_DEMAND_CLASS VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
UNIT_NUMBER VARCHAR2 (30)
END_UNIT_NUMBER VARCHAR2 (30)
ITEM_DESC VARCHAR2 (240)
END_LENDING_PROJECT_NUMBER VARCHAR2 (4000)
END_LENDING_TASK_NUMBER VARCHAR2 (4000)
Query Text

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


SELECT ROW_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      PEGGING_ID
,      PREV_PEGGING_ID
,      DEMAND_ID
,      TRANSACTION_ID
,      END_ITEM_USAGE
,      INVENTORY_ITEM_ID
,      ITEM_ORG
,      SUPPLY_QTY
,      PEGGED_QTY
,      SUPPLY_DATE
,      DEMAND_QTY
,      DEMAND_DATE
,      ORDER_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      ORDER_TYPE
,      DISPOSITION
,      END_PEGGED_QTY
,      END_DEMAND_QTY
,      END_DEMAND_DATE
,      END_ITEM_ORG
,      END_ITEM_DESC
,      END_ORIGINATION_NAME
,      END_DISPOSITION
,      END_PROJECT_NUMBER
,      END_TASK_NUMBER
,      END_DEMAND_CLASS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UNIT_NUMBER
,      END_UNIT_NUMBER
,      ITEM_DESC
,      END_LENDING_PROJECT_NUMBER
,      END_LENDING_TASK_NUMBER
FROM APPS.MRP_FLP_DEMAND_SUPPLY_V2;

Dependencies

[top of page]

APPS.MRP_FLP_DEMAND_SUPPLY_V2 references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_FULL_PEGGING
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_ITEM_PURCHASE_ORDERS
SynonymMRP_RECOMMENDATIONS
SynonymMRP_SCHEDULE_DATES
SynonymMTL_DEMAND
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_PARAMETERS
SynonymMTL_SALES_ORDERS
SynonymOE_ORDER_LINES_ALL
SynonymWIP_ENTITIES

APPS.MRP_FLP_DEMAND_SUPPLY_V2 is not referenced by any database object