Skip to content

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

VIEW: APPS.MSC_FLP_SUPPLY_DEMAND_V2

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

DEMAND_ID NUMBER

TRANSACTION_ID NUMBER

END_ITEM_USAGE NUMBER

DEMAND_QTY NUMBER

DEMAND_DATE DATE
Yes
SUPPLY_QTY NUMBER

ITEM_ID NUMBER
Yes
ITEM_ORG VARCHAR2 (4000)
ITEM_DESC VARCHAR2 (80)
PEGGED_QTY NUMBER

ORIGINATION_NAME VARCHAR2 (4000)
PROJECT_NUMBER VARCHAR2 (4000)
TASK_NUMBER VARCHAR2 (4000)
END_PEGGED_QTY NUMBER

END_DEMAND_QTY NUMBER

END_DEMAND_DATE DATE

END_ITEM_ORG VARCHAR2 (4000)
END_ITEM_DESC VARCHAR2 (80)
END_ORIGINATION_NAME VARCHAR2 (4000)
END_DISPOSITION VARCHAR2 (4000)
END_PROJECT_NUMBER VARCHAR2 (4000)
END_TASK_NUMBER VARCHAR2 (4000)
PREV_SUPPLY_QTY NUMBER

PREV_SUPPLY_DATE DATE
Yes
PREV_ITEM_ORG VARCHAR2 (4000)
PREV_ITEM_DESC VARCHAR2 (80)
PREV_ITEM_ID NUMBER
Yes
PREV_DEMAND_ID NUMBER

PREV_PEGGED_QTY NUMBER

NEW_PROCESSING_DAYS NUMBER

ORDER_NAME VARCHAR2 (4000)
ORDER_TYPE NUMBER
Yes
PREV_DISPOSITION VARCHAR2 (240)
END_DEMAND_CLASS VARCHAR2 (34)
UNIT_NUMBER VARCHAR2 (30)
END_UNIT_NUMBER VARCHAR2 (30)
PREV_UNIT_NUMBER VARCHAR2 (30)
PREV_PROJECT_NUMBER VARCHAR2 (4000)
PREV_TASK_NUMBER VARCHAR2 (4000)
LENDING_PROJECT_NUMBER VARCHAR2 (4000)
LENDING_TASK_NUMBER VARCHAR2 (4000)
END_LENDING_PROJECT_NUMBER VARCHAR2 (4000)
END_LENDING_TASK_NUMBER VARCHAR2 (4000)
SR_INSTANCE_ID NUMBER
Yes
END_SATISFIED_DATE DATE

CUSTOMER VARCHAR2 (4000)
DEMAND_PRIORITY NUMBER

END_CUSTOMER VARCHAR2 (4000)
END_DEMAND_PRIORITY NUMBER

PREV_CUSTOMER VARCHAR2 (4000)
PREV_DEMAND_PRIORITY NUMBER

ATTRIBUTE1 VARCHAR2 (150)
SATISFIED_DATE DATE

PREV_SATISFIED_DATE DATE

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
,      END_ITEM_USAGE
,      DEMAND_QTY
,      DEMAND_DATE
,      SUPPLY_QTY
,      ITEM_ID
,      ITEM_ORG
,      ITEM_DESC
,      PEGGED_QTY
,      ORIGINATION_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      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
,      PREV_SUPPLY_QTY
,      PREV_SUPPLY_DATE
,      PREV_ITEM_ORG
,      PREV_ITEM_DESC
,      PREV_ITEM_ID
,      PREV_DEMAND_ID
,      PREV_PEGGED_QTY
,      NEW_PROCESSING_DAYS
,      ORDER_NAME
,      ORDER_TYPE
,      PREV_DISPOSITION
,      END_DEMAND_CLASS
,      UNIT_NUMBER
,      END_UNIT_NUMBER
,      PREV_UNIT_NUMBER
,      PREV_PROJECT_NUMBER
,      PREV_TASK_NUMBER
,      LENDING_PROJECT_NUMBER
,      LENDING_TASK_NUMBER
,      END_LENDING_PROJECT_NUMBER
,      END_LENDING_TASK_NUMBER
,      SR_INSTANCE_ID
,      END_SATISFIED_DATE
,      CUSTOMER
,      DEMAND_PRIORITY
,      END_CUSTOMER
,      END_DEMAND_PRIORITY
,      PREV_CUSTOMER
,      PREV_DEMAND_PRIORITY
,      ATTRIBUTE1
,      SATISFIED_DATE
,      PREV_SATISFIED_DATE
FROM APPS.MSC_FLP_SUPPLY_DEMAND_V2;

Dependencies

[top of page]

APPS.MSC_FLP_SUPPLY_DEMAND_V2 references the following:

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

APPS.MSC_FLP_SUPPLY_DEMAND_V2 is not referenced by any database object