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

VIEW: APPS.MSC_FLP_SUPPLY_DEMAND_V3

Object Details
Object Name: MSC_FLP_SUPPLY_DEMAND_V3
Object Type: VIEW
Owner: APPS
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)
PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PEGGING_ID NUMBER
Yes
PREV_PEGGING_ID NUMBER

DEMAND_ID NUMBER

TRANSACTION_ID NUMBER

DEMAND_QTY NUMBER

DEMAND_DATE DATE

ITEM_ID NUMBER
Yes
ITEM_ORG VARCHAR2 (4000)
PEGGED_QTY NUMBER

ORIGINATION_NAME VARCHAR2 (4000)
END_PEGGED_QTY NUMBER

END_DEMAND_QTY NUMBER

END_DEMAND_DATE DATE

END_ITEM_ORG VARCHAR2 (4000)
END_ORIGINATION_NAME VARCHAR2 (4000)
END_SATISFIED_DATE DATE

END_DISPOSITION VARCHAR2 (4000)
ORDER_TYPE NUMBER

END_DEMAND_CLASS VARCHAR2 (34)
SR_INSTANCE_ID NUMBER
Yes
OP_SEQ_NUM NUMBER

ITEM_DESC_ORG VARCHAR2 (4000)
Query Text

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


SELECT ROW_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      PEGGING_ID
,      PREV_PEGGING_ID
,      DEMAND_ID
,      TRANSACTION_ID
,      DEMAND_QTY
,      DEMAND_DATE
,      ITEM_ID
,      ITEM_ORG
,      PEGGED_QTY
,      ORIGINATION_NAME
,      END_PEGGED_QTY
,      END_DEMAND_QTY
,      END_DEMAND_DATE
,      END_ITEM_ORG
,      END_ORIGINATION_NAME
,      END_SATISFIED_DATE
,      END_DISPOSITION
,      ORDER_TYPE
,      END_DEMAND_CLASS
,      SR_INSTANCE_ID
,      OP_SEQ_NUM
,      ITEM_DESC_ORG
FROM APPS.MSC_FLP_SUPPLY_DEMAND_V3;

Dependencies

[top of page]

APPS.MSC_FLP_SUPPLY_DEMAND_V3 references the following:

SchemaAPPS
SynonymMSC_DEMANDS
SynonymMSC_FULL_PEGGING
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_SUPPLIES
SynonymMSC_SYSTEM_ITEMS
APPS.MSC_FLP_SUPPLY_DEMAND_V3 is referenced by following:

SchemaAPPS
Package BodyMSC_UI_PEG_UTIL - show dependent code