[Home] [Help]
[Dependency Information]
VIEW: APPS.MTL_PROJECT_V
Object Details
Object Name: | MTL_PROJECT_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.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:
-
APPS
-
FND_PROFILE
- show dependent code
-
MRP_GET_PROJECT
- show dependent code
-
PA_CROSS_BUSINESS_GRP
- show dependent code
-
PA_PROJECT_UTILS
- show dependent code
-
PA_SECURITY
- show dependent code
-
PJM_ORG_PROJECTS_V
APPS.MTL_PROJECT_V is referenced by following:
-
APPS
-
CST_PAC_WIP_TXN_V
-
EAM_WO_VALIDATE_PVT
- show dependent code
-
INVKBCGN
- show dependent code
-
INV_INVIRILC_XMLP_PKG
- show dependent code
-
INV_PROJECT
- show dependent code
-
INV_UTILITIES
- show dependent code
-
MRP_ID_TO_VALUE
- show dependent code
-
MRP_PROJECT_V
-
MRP_VALIDATE
- show dependent code
-
MRP_VALUE_TO_ID
- show dependent code
-
POR_PROJECT_LOV_V
-
WIP_FLOW_VALIDATION
- show dependent code
-
WIP_VALIDATE
- show dependent code