[Home] [Help]
[Dependency Information]
VIEW: APPS.PJM_PROJECTS_MTLL_V
Object Details
Object Name: | PJM_PROJECTS_MTLL_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJM.PJM_PROJECTS_MTLL_V
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PROJECT_ID |
NUMBER |
(15) |
|
|
PROJECT_NUMBER |
VARCHAR2 |
(25) |
|
|
PROJECT_NAME |
VARCHAR2 |
(30) |
|
|
PROJECT_DESCRIPTION |
VARCHAR2 |
(250) |
|
|
PROJECT_NUMBER_SORT_ORDER |
VARCHAR2 |
(25) |
|
|
START_DATE |
DATE |
|
|
|
COMPLETION_DATE |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, PROJECT_NUMBER_SORT_ORDER
, START_DATE
, COMPLETION_DATE
FROM APPS.PJM_PROJECTS_MTLL_V;
Dependencies
[top of page]
APPS.PJM_PROJECTS_MTLL_V references the following:
-
APPS
-
FND_PROFILE
- show dependent code
-
PA_CROSS_BUSINESS_GRP
- show dependent code
-
PA_PROJECT_UTILS
- show dependent code
-
PA_SECURITY
- show dependent code
-
PJM_ORG_PARAMETERS
-
PJM_PROJECTS_ALL_V
-
PJM_PROJECT_PARAMETERS
APPS.PJM_PROJECTS_MTLL_V is referenced by following:
-
APPS
-
INV_LABEL_PVT1
- show dependent code
-
INV_LABEL_PVT2
- show dependent code
-
INV_UI_PROJECT_LOVS
- show dependent code
-
WMS_RULES_WORKBENCH_PVT
- show dependent code