[Home] [Help] [Dependency Information]

VIEW: APPS.MRP_WEB_HORIZONTAL_PLAN_V

Object Details

Object Name:	MRP_WEB_HORIZONTAL_PLAN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_WEB_HORIZONTAL_PLAN_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This view is used by the Planning Web Inquiries to display the
horizontal plan information for a plan and is based on
MRP_MATERIAL_PLANS.

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      HORIZONTAL_PLAN_TYPE
,      HORIZONTAL_PLAN_TYPE_TEXT
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
,      COLUMN13
,      COLUMN14
,      COLUMN15
,      COLUMN16
,      COLUMN17
,      COLUMN18
,      COLUMN19
,      COLUMN20
,      COLUMN21
,      COLUMN22
,      COLUMN23
,      COLUMN24
,      COLUMN25
,      COLUMN26
,      COLUMN27
,      COLUMN28
,      COLUMN29
,      COLUMN30
,      COLUMN31
,      COLUMN32
,      COLUMN33
,      COLUMN34
,      COLUMN35
,      COLUMN36
,      PLANNING_GROUP
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
FROM APPS.MRP_WEB_HORIZONTAL_PLAN_V;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

MRP_GET_PROJECT - show dependent code

MRP_MATERIAL_PLANS

MRP_PROJECT_V

MRP_TASK_V

MRP_WORKBENCH_BUCKET_DATES

MTL_PARAMETERS

PA_CROSS_BUSINESS_GRP - show dependent code

PA_PROJECT_UTILS - show dependent code

PA_SECURITY - show dependent code

PA_TASK_UTILS - show dependent code

APPS.MRP_WEB_HORIZONTAL_PLAN_V is not referenced by any database object