DBA Data[Home] [Help]

VIEW: APPS.PJM_TASKS_OU_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , PJM_PROJECT.ALL_PROJ_IDTONUM(T.PROJECT_ID) , PJM_PROJECT.ALL_PROJ_IDTONAME(T.PROJECT_ID) , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.WBS_SORT_ORDER , T.START_DATE , T.COMPLETION_DATE , T.BILLABLE_FLAG , T.CHARGEABLE_FLAG , T.ALLOW_CROSS_CHARGE_FLAG , T.EXPENDITURE_ORG_ID FROM PA_TASKS_ALL_EXPEND_V T
View Text - HTML Formatted

SELECT T.PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(T.PROJECT_ID)
, PJM_PROJECT.ALL_PROJ_IDTONAME(T.PROJECT_ID)
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.WBS_SORT_ORDER
, T.START_DATE
, T.COMPLETION_DATE
, T.BILLABLE_FLAG
, T.CHARGEABLE_FLAG
, T.ALLOW_CROSS_CHARGE_FLAG
, T.EXPENDITURE_ORG_ID
FROM PA_TASKS_ALL_EXPEND_V T