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


VIEW: APPS.MSC_FLP_END_DEMAND_V

Object Details
Object Name: MSC_FLP_END_DEMAND_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_FLP_END_DEMAND_V
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)
ORGANIZATION_ID NUMBER
Yes
PLAN_ID NUMBER
Yes
PEGGING_ID NUMBER
Yes
TRANSACTION_ID NUMBER

DEMAND_ID NUMBER

PREV_PEGGING_ID NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
DEMAND_QUANTITY NUMBER

SUPPLY_QUANTITY NUMBER

ALLOCATED_QUANTITY NUMBER

DEMAND_DATE DATE

ORIGINATION_NAME VARCHAR2 (4000)
DISPOSITION VARCHAR2 (4000)
ITEM_ORG VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (80)
PROJECT_NUMBER VARCHAR2 (4000)
TASK_NUMBER VARCHAR2 (4000)
END_DEMAND_CLASS VARCHAR2 (34)
UNIT_NUMBER VARCHAR2 (30)
LENDING_PROJECT_NUMBER VARCHAR2 (4000)
LENDING_TASK_NUMBER VARCHAR2 (4000)
SR_INSTANCE_ID NUMBER
Yes
SATISFIED_DATE DATE

CUSTOMER VARCHAR2 (4000)
DEMAND_PRIORITY NUMBER

ATTRIBUTE1 VARCHAR2 (150)
ITEM_DESC_ORG VARCHAR2 (4000)
Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      PLAN_ID
,      PEGGING_ID
,      TRANSACTION_ID
,      DEMAND_ID
,      PREV_PEGGING_ID
,      INVENTORY_ITEM_ID
,      DEMAND_QUANTITY
,      SUPPLY_QUANTITY
,      ALLOCATED_QUANTITY
,      DEMAND_DATE
,      ORIGINATION_NAME
,      DISPOSITION
,      ITEM_ORG
,      DESCRIPTION
,      PROJECT_NUMBER
,      TASK_NUMBER
,      END_DEMAND_CLASS
,      UNIT_NUMBER
,      LENDING_PROJECT_NUMBER
,      LENDING_TASK_NUMBER
,      SR_INSTANCE_ID
,      SATISFIED_DATE
,      CUSTOMER
,      DEMAND_PRIORITY
,      ATTRIBUTE1
,      ITEM_DESC_ORG
FROM APPS.MSC_FLP_END_DEMAND_V;

Dependencies

[top of page]

APPS.MSC_FLP_END_DEMAND_V references the following:

SchemaAPPS
SynonymMSC_DEMANDS
SynonymMSC_FULL_PEGGING
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_ITEMS
SynonymMSC_SUPPLIES

APPS.MSC_FLP_END_DEMAND_V is not referenced by any database object