VIEW: APPS.PA_NG_BUDGET_BY_RESOURCE_V

Source

View Text - Preformatted

SELECT BUDGET_VERSION_ID , PROJECT_ID , TASK_ID , BUDGET_TYPE_CODE , 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_RESOURCE_V UNION SELECT A.BUDGET_VERSION_ID, A.PROJECT_ID, A.TASK_ID, A.BUDGET_TYPE_CODE, 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_RESOURCE_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'

View Text - HTML Formatted

SELECT BUDGET_VERSION_ID
, PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, 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_RESOURCE_V UNION SELECT A.BUDGET_VERSION_ID
, A.PROJECT_ID
, A.TASK_ID
, A.BUDGET_TYPE_CODE
, 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_RESOURCE_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'