Product: | PA - Projects |
---|---|
Description: | 10Sc Only |
Implementation/DBA Data: | APPS.PA_NG_BUDGET_BY_PA_PERIOD_V |
SELECT BUDGET_VERSION_ID
, PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, PA_PERIOD
, GL_PERIOD_NAME
, PERIOD_YEAR
, PERIOD_START_DATE
, PERIOD_END_DATE
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, RESOURCE_ID
, RESOURCE_ACCUMULATED_FLAG
, RAW_COST
, BURDENED_COST
, REVENUE
, QUANTITY
, TO_NUMBER(LABOR_QUANTITY)
, 0
, 0
, 0
, 0
, 0
, TO_CHAR(NULL)
FROM PA_BASE_BUDGET_BY_PA_PERIOD_V UNION SELECT A.BUDGET_VERSION_ID
, B.PROJECT_ID
, A.TASK_ID
, A.BUDGET_TYPE_CODE
, A.PA_PERIOD
, A.GL_PERIOD_NAME
, A.PERIOD_YEAR
, A.PERIOD_START_DATE
, A.PERIOD_END_DATE
, A.RESOURCE_LIST_MEMBER_ID
, A.RESOURCE_LIST_ID
, A.RESOURCE_ID
, B.RESOURCE_ACCUMULATED_FLAG
, 0
, 0
, 0
, 0
, 0
, A.RAW_COST
, A.BURDENED_COST
, A.REVENUE
, A.QUANTITY
, TO_NUMBER(A.LABOR_QUANTITY)
, A.UNIT_OF_MEASURE
FROM PA_ORIG_BUDGET_BY_PA_PERIOD_V A
, PA_BUDGET_VERSIONS B
WHERE A.PROJECT_ID = B.PROJECT_ID
AND A.BUDGET_TYPE_CODE = B.BUDGET_TYPE_CODE
AND B.CURRENT_FLAG = 'Y'