[Home] [Help] [Dependency Information]
Object Name: | PJM_TASKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJM.PJM_TASKS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PJM_TASKS_V returns a list of tasks based on the value of the profile 'PA: Tasks to Display for Expenditure Entry' (PA_TASKS_DISPLAYED). Those tasks are chargiable for the OU corresponding to the inventory organization
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | System-generated number that uniquely identifies a project |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | User-entered number that uniquely identifies a project |
PROJECT_NAME | VARCHAR2 | (30) | Yes | User-entered project name |
TASK_ID | NUMBER | (15) | Yes | System-generated number that uniquely identifies a task |
TASK_NUMBER | VARCHAR2 | (25) | Yes | User-entered string that uniquely identifies a task within a project |
TASK_NAME | VARCHAR2 | (20) | Yes | User-entered task name |
WBS_SORT_ORDER | VARCHAR2 | (2000) | Order sequence based on work breakdown structure | |
START_DATE | DATE | Task start date | ||
COMPLETION_DATE | DATE | Task completion date | ||
BILLABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether task is billable | |
CHARGEABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether task is chargeable | |
ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether cross charges are allowed for this task |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, WBS_SORT_ORDER
, START_DATE
, COMPLETION_DATE
, BILLABLE_FLAG
, CHARGEABLE_FLAG
, ALLOW_CROSS_CHARGE_FLAG
FROM APPS.PJM_TASKS_V;
|
|
|