[Home] [Help]
[Dependency Information]
VIEW: APPS.PJM_PROJECTS_V
Object Details
Object Name: | PJM_PROJECTS_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJM.PJM_PROJECTS_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
PJM_PROJECTS_V returns all chargeable projects and seiban numbers for the OU corresponding to the inventory organization.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PROJECT_ID |
NUMBER |
(15) |
|
System-generated number that uniquely identifies a project or seiban |
PROJECT_NUMBER |
VARCHAR2 |
(25) |
|
User-entered number that uniquely identifies a project or seiban |
PROJECT_NAME |
VARCHAR2 |
(30) |
|
User-entered project/seiban name |
PROJECT_DESCRIPTION |
VARCHAR2 |
(250) |
|
Project description |
PROJECT_NUMBER_SORT_ORDER |
VARCHAR2 |
(25) |
|
Sort order for project |
START_DATE |
DATE |
|
|
Project start date |
COMPLETION_DATE |
DATE |
|
|
Project completion date |
SEIBAN_NUMBER_FLAG |
NUMBER |
|
|
Flag indicating whether the PROJECT_ID identifier identifies a project or seiban |
ORG_ID |
NUMBER |
|
|
Operating unit unique identifer |
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
, SEIBAN_NUMBER_FLAG
, ORG_ID
FROM APPS.PJM_PROJECTS_V;
Dependencies
[top of page]
APPS.PJM_PROJECTS_V references the following:
-
APPS
-
FND_PROFILE
- show dependent code
-
HR_ORGANIZATION_INFORMATION
-
PA_BUDGETARY_CONTROL_OPTIONS
-
PA_CC_ORG_RELATIONSHIPS
-
PA_CROSS_BUSINESS_GRP
- show dependent code
-
PA_IMPLEMENTATIONS_ALL
-
PA_PROJECTS_ALL
-
PA_PROJECTS_ALL_BASIC_V
-
PA_PROJECT_UTILS
- show dependent code
-
PA_SECURITY
- show dependent code
-
PJM_SEIBAN_NUMBERS
APPS.PJM_PROJECTS_V is referenced by following:
-
APPS
-
CSD_PROJECT_DETAILS_V
-
CSD_REPAIRS_NON_SEC_V
-
CSD_REPAIRS_V
-
EAM_WORKORDERS_JSP
- show dependent code
-
ENG_ENGINEERING_CHANGES_V
-
ICX_EDM_COST_GROUP_INV_V
-
ICX_EDM_INV_ONHAND_BAL_V
-
INVFV_MOVE_ORDERS_LINES
-
INV_INVTOPKL_XMLP_PKG
- show dependent code
-
INV_MWB_QUERY_MANAGER
- show dependent code
-
INV_VALIDATE
- show dependent code
-
MRPPA_PROJECTS_V
-
PJM_ORG_PROJECTS_V
-
PJM_PROJECT
- show dependent code
-
PJM_PROJECTS_ORG_V
-
PJM_PROJECT_LOCATOR
- show dependent code
-
QA_FLEX_UTIL
- show dependent code
-
WIP_EAM_UTILS
- show dependent code
-
WIP_JSI_VALIDATOR
- show dependent code
-
WIP_VALIDATEMLHEADER_PVT
- show dependent code