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

VIEW: APPS.MSC_VERTICAL_PLAN_V

Object Details
Object Name: MSC_VERTICAL_PLAN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_VERTICAL_PLAN_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
TRANSACTION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
PLAN_ID NUMBER

SR_INSTANCE_ID NUMBER

NEW_DUE_DATE DATE

ORDER_NUMBER VARCHAR2 (4000)
ORDER_TYPE NUMBER

ORDER_TYPE_TEXT VARCHAR2 (4000)
QUANTITY_RATE NUMBER

ITEM_SEGMENTS VARCHAR2 (250)
DESCRIPTION VARCHAR2 (240)
PRODUCT_FAMILY_ID NUMBER

PRODUCT_FAMILY_NAME VARCHAR2 (0)
PLANNING_GROUP VARCHAR2 (30)
PROJECT_ID NUMBER

TASK_ID NUMBER

DUMMY_SORT NUMBER

SOURCE_FLAG NUMBER

PROBABILITY NUMBER

USING_REQUIREMENT_QUANTITY NUMBER

Query Text

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


SELECT TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ID
,      SR_INSTANCE_ID
,      NEW_DUE_DATE
,      ORDER_NUMBER
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      QUANTITY_RATE
,      ITEM_SEGMENTS
,      DESCRIPTION
,      PRODUCT_FAMILY_ID
,      PRODUCT_FAMILY_NAME
,      PLANNING_GROUP
,      PROJECT_ID
,      TASK_ID
,      DUMMY_SORT
,      SOURCE_FLAG
,      PROBABILITY
,      USING_REQUIREMENT_QUANTITY
FROM APPS.MSC_VERTICAL_PLAN_V;

Dependencies

[top of page]

APPS.MSC_VERTICAL_PLAN_V references the following:

SchemaAPPS
SynonymMSC_CALENDAR_DATES
SynonymMSC_DEMANDS
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_SALES_ORDERS
SynonymMSC_SUPPLIES
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS
APPS.MSC_VERTICAL_PLAN_V is referenced by following:

SchemaAPPS
Package BodyMSC_VERTICAL_PLAN_SC - show dependent code