DBA Data[Home] [Help]

VIEW: PA.PA_EARNED_VALUES#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, AS_OF_DATE AS_OF_DATE, CURRENT_FLAG CURRENT_FLAG, BCWS BCWS, ACWP ACWP, BCWP BCWP, BAC BAC, BCWS_ITD BCWS_ITD, ACWP_ITD ACWP_ITD, BCWP_ITD BCWP_ITD, BAC_ITD BAC_ITD, BQWS BQWS, AQWP AQWP, BQWP BQWP, BAQ BAQ, BQWS_ITD BQWS_ITD, AQWP_ITD AQWP_ITD, BQWP_ITD BQWP_ITD, BAQ_ITD BAQ_ITD, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_EARNED_VALUES"
View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, AS_OF_DATE AS_OF_DATE
, CURRENT_FLAG CURRENT_FLAG
, BCWS BCWS
, ACWP ACWP
, BCWP BCWP
, BAC BAC
, BCWS_ITD BCWS_ITD
, ACWP_ITD ACWP_ITD
, BCWP_ITD BCWP_ITD
, BAC_ITD BAC_ITD
, BQWS BQWS
, AQWP AQWP
, BQWP BQWP
, BAQ BAQ
, BQWS_ITD BQWS_ITD
, AQWP_ITD AQWP_ITD
, BQWP_ITD BQWP_ITD
, BAQ_ITD BAQ_ITD
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_EARNED_VALUES"