eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSC_PDR_VERT_LIST_V

Object Details

Object Name:	MSC_PDR_VERT_LIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_PDR_VERT_LIST_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length
ORGANIZATION	VARCHAR2	(7)
PRODUCT_CATEGORY	VARCHAR2	(250)
ITEM	VARCHAR2	(250)
PLANNING_GROUP	VARCHAR2	(30)
PROJECT	NUMBER	(15)
TASK	NUMBER	(15)
ORDER_TYPE	VARCHAR2	(80)
ORDER_NUMBER	VARCHAR2	(4000)
CALENDAR_DATE	DATE
PLANNER_ACTION	VARCHAR2	(4000)
SUGGESTED_QUANTITY_RATE	NUMBER
OLD_DUE_DATE	DATE
SUGGESTED_ORDER_DATE	DATE
SUGGESTED_DUE_DATE	DATE
SUGGESTED_DOCK_DATE	DATE
SUGGESTED_START_DATE	DATE
SUGGESTED_IMPLEMENTATION_TYPE	NUMBER
FIRM_DATE	DATE
FIRM_QUANTITY	NUMBER
OUTSTANDING_QUANTITY	NUMBER
COMPRESSION_DAYS	NUMBER
USING_ASSEMBLY	VARCHAR2	(4000)
DEMAND_SCHEDULE	VARCHAR2	(4000)
SUPPLY_SCHEDULE	VARCHAR2	(4000)
SOURCE_ORG	VARCHAR2	(4000)
SOURCE_SUPPLIER	VARCHAR2	(4000)
PLAN	VARCHAR2	(10)
REPORT_CREATION_DATE	DATE
PLAN_ID	NUMBER
ORGANIZATION_ID	NUMBER
SR_INSTANCE_ID	NUMBER
CATEGORY_SET_ID	NUMBER
PRODUCT_CATEGORY_ID	NUMBER
ABC_CLASS_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
PLANNER_CODE_ID	VARCHAR2	(10)
BUYER_NAME_ID	VARCHAR2	(240)
SUPPLIER_ID	NUMBER
PLANNING_GROUP_ID	VARCHAR2	(0)
PROJECT_ID	VARCHAR2	(0)
RESOURCE_GROUP_ID	VARCHAR2	(0)
DEPT_LINE_ID	VARCHAR2	(0)
RESOURCE_ID	VARCHAR2	(0)
RECORD_DATE	VARCHAR2	(0)
IMPLEMENT_AS_TEXT	VARCHAR2	(4000)
PROJECT_NUMBER	VARCHAR2	(4000)
TASK_NUMBER	VARCHAR2	(4000)
QTY_FOR_CUM_CALC	NUMBER

Query Text

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


SELECT ORGANIZATION
,      PRODUCT_CATEGORY
,      ITEM
,      PLANNING_GROUP
,      PROJECT
,      TASK
,      ORDER_TYPE
,      ORDER_NUMBER
,      CALENDAR_DATE
,      PLANNER_ACTION
,      SUGGESTED_QUANTITY_RATE
,      OLD_DUE_DATE
,      SUGGESTED_ORDER_DATE
,      SUGGESTED_DUE_DATE
,      SUGGESTED_DOCK_DATE
,      SUGGESTED_START_DATE
,      SUGGESTED_IMPLEMENTATION_TYPE
,      FIRM_DATE
,      FIRM_QUANTITY
,      OUTSTANDING_QUANTITY
,      COMPRESSION_DAYS
,      USING_ASSEMBLY
,      DEMAND_SCHEDULE
,      SUPPLY_SCHEDULE
,      SOURCE_ORG
,      SOURCE_SUPPLIER
,      PLAN
,      REPORT_CREATION_DATE
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      CATEGORY_SET_ID
,      PRODUCT_CATEGORY_ID
,      ABC_CLASS_ID
,      INVENTORY_ITEM_ID
,      PLANNER_CODE_ID
,      BUYER_NAME_ID
,      SUPPLIER_ID
,      PLANNING_GROUP_ID
,      PROJECT_ID
,      RESOURCE_GROUP_ID
,      DEPT_LINE_ID
,      RESOURCE_ID
,      RECORD_DATE
,      IMPLEMENT_AS_TEXT
,      PROJECT_NUMBER
,      TASK_NUMBER
,      QTY_FOR_CUM_CALC
FROM APPS.MSC_PDR_VERT_LIST_V;

Dependencies

[top of page]

APPS.MSC_PDR_VERT_LIST_V references the following:

APPS: FND_GLOBAL - show dependent code; MFG_LOOKUPS; MSC_CALENDAR_DATES; MSC_DEMANDS; MSC_GET_NAME - show dependent code; MSC_ITEM_CATEGORIES; MSC_PDR_PARAMETERS; MSC_PLANS; MSC_SUPPLIES; MSC_SYSTEM_ITEMS; MSC_TRADING_PARTNERS

APPS.MSC_PDR_VERT_LIST_V is not referenced by any database object