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


VIEW: APPS.MTL_PROJECT_V

Object Details
Object Name: MTL_PROJECT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_PROJECT_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
PROJECT_ID NUMBER (15)

PROJECT_NUMBER VARCHAR2 (25)

PROJECT_NAME VARCHAR2 (30)

START_DATE DATE

COMPLETION_DATE DATE

PROJECT_NUMBER_SORT_ORDER VARCHAR2 (25)
PLANNING_GROUP VARCHAR2 (4000)

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      START_DATE
,      COMPLETION_DATE
,      PROJECT_NUMBER_SORT_ORDER
,      PLANNING_GROUP
FROM APPS.MTL_PROJECT_V;

Dependencies

[top of page]

APPS.MTL_PROJECT_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageMRP_GET_PROJECT - show dependent code
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_PROJECT_UTILS - show dependent code
PL/SQL PackagePA_SECURITY - show dependent code
ViewPJM_ORG_PROJECTS_V
APPS.MTL_PROJECT_V is referenced by following:

SchemaAPPS
ViewCST_PAC_WIP_TXN_V
Package BodyEAM_WO_VALIDATE_PVT - show dependent code
Package BodyINVKBCGN - show dependent code
Package BodyINV_INVIRILC_XMLP_PKG - show dependent code
Package BodyINV_PROJECT - show dependent code
Package BodyINV_UTILITIES - show dependent code
Package BodyMRP_ID_TO_VALUE - show dependent code
ViewMRP_PROJECT_V
Package BodyMRP_VALIDATE - show dependent code
Package BodyMRP_VALUE_TO_ID - show dependent code
ViewPOR_PROJECT_LOV_V
Package BodyWIP_FLOW_VALIDATION - show dependent code
Package BodyWIP_VALIDATE - show dependent code