eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_BUDGET_MATRIX_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_BUDGET_MATRIX_V

View Text

SELECT B.BUDGET_VERSION_ID
, B.TASK_ID
, DECODE(A.LOOKUP_CODE
, 'QU'
, C.QUANTITY
, 'RC'
, C.RAW_COST
, 'BC'
, C.BURDENED_COST
, 'RE'
, C.REVENUE )
, DECODE(A.LOOKUP_CODE
, 'QU'
, C2.QUANTITY
, 'RC'
, C2.RAW_COST
, 'BC'
, C2.BURDENED_COST
, 'RE'
, C2.REVENUE)
, DECODE(A.LOOKUP_CODE
, 'QU'
, C3.QUANTITY
, 'RC'
, C3.RAW_COST
, 'BC'
, C3.BURDENED_COST
, 'RE'
, C3.REVENUE)
, DECODE(A.LOOKUP_CODE
, 'QU'
, C4.QUANTITY
, 'RC'
, C4.RAW_COST
, 'BC'
, C4.BURDENED_COST
, 'RE'
, C4.REVENUE)
, B.RESOURCE_ASSIGNMENT_ID
, D.RESOURCE_LIST_MEMBER_ID
, D.RESOURCE_LIST_ID
, D.RESOURCE_ID
, D.ALIAS ALIAS
, B.UNIT_OF_MEASURE
, B.TRACK_AS_LABOR_FLAG
, A.LOOKUP_CODE
, DECODE(A.LOOKUP_CODE
, 'QU'
, E.MEANING
, A.MEANING)
, DECODE(A.LOOKUP_CODE
, 'RC'
, 2
, 'BC'
, 3
, 'QU'
, 1
, 'RE'
, 4)
, RPAD(NVL(C.ATTRIBUTE1
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE2
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE3
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE4
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE5
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE6
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE7
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE8
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE9
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE10
, '/
, .')
, 153
, '(|)') DF_LONG_P1_1
, RPAD(NVL(C.ATTRIBUTE11
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE12
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE13
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE14
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE15
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.ATTRIBUTE_CATEGORY
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.CHANGE_REASON_CODE
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C.DESCRIPTION
, '/
, .')
, 258
, '(|)')DF_LONG_P1_2
, RPAD(NVL(C2.ATTRIBUTE1
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE2
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE3
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE4
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE5
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE6
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE7
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE8
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE9
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE10
, '/
, .')
, 153
, '(|)') DF_LONG_P2_1
, RPAD(NVL(C2.ATTRIBUTE11
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE12
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE13
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE14
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE15
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.ATTRIBUTE_CATEGORY
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.CHANGE_REASON_CODE
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C2.DESCRIPTION
, '/
, .')
, 258
, '(|)')DF_LONG_P2_2
, RPAD(NVL(C3.ATTRIBUTE1
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE2
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE3
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE4
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE5
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE6
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE7
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE8
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE9
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE10
, '/
, .')
, 153
, '(|)') DF_LONG_P3_1
, RPAD(NVL(C3.ATTRIBUTE11
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE12
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE13
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE14
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE15
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.ATTRIBUTE_CATEGORY
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.CHANGE_REASON_CODE
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C3.DESCRIPTION
, '/
, .')
, 258
, '(|)')DF_LONG_P3_2
, RPAD(NVL(C4.ATTRIBUTE1
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE2
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE3
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE4
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE5
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE6
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE7
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE8
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE9
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE10
, '/
, .')
, 153
, '(|)') DF_LONG_P4_1
, RPAD(NVL(C4.ATTRIBUTE11
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE12
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE13
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE14
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE15
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.ATTRIBUTE_CATEGORY
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.CHANGE_REASON_CODE
, '/
, .')
, 153
, '(|)') || RPAD(NVL(C4.DESCRIPTION
, '/
, .')
, 258
, '(|)')DF_LONG_P4_2
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, SYSDATE
, -1
, SYSDATE
, -1
, -1
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_LOGIN
, C2.LAST_UPDATE_DATE
, C2.LAST_UPDATED_BY
, C2.CREATION_DATE
, C2.CREATED_BY
, C2.LAST_UPDATE_LOGIN
, C3.LAST_UPDATE_DATE
, C3.LAST_UPDATED_BY
, C3.CREATION_DATE
, C3.CREATED_BY
, C3.LAST_UPDATE_LOGIN
, C4.LAST_UPDATE_DATE
, C4.LAST_UPDATED_BY
, C4.CREATION_DATE
, C4.CREATED_BY
, C4.LAST_UPDATE_LOGIN
, D.PARENT_MEMBER_ID
FROM FND_LOOKUP_VALUES A
, FND_LOOKUP_VALUES E
, PA_RESOURCE_LIST_MEMBERS D
, PA_RESOURCE_ASSIGNMENTS B
, PA_BUDGET_LINES C
, PA_BUDGET_LINES C2
, PA_BUDGET_LINES C3
, PA_BUDGET_LINES C4
WHERE B.BUDGET_VERSION_ID = PA_BUDGET_MATRIX.GET_BUDGET_VERSION_ID
AND B.PROJECT_ID = PA_BUDGET_MATRIX.GET_PROJECT_ID
AND B.TASK_ID = PA_BUDGET_MATRIX.GET_TASK_ID
AND NVL(D.MIGRATION_CODE
, '-99') <> 'N'
AND 'BUDGET AMOUNT TYPES' = A.LOOKUP_TYPE(+)
AND A.LANGUAGE (+) = USERENV('LANG')
AND A.VIEW_APPLICATION_ID (+) = 275
AND B.RESOURCE_LIST_MEMBER_ID = D.RESOURCE_LIST_MEMBER_ID
AND B.UNIT_OF_MEASURE = E.LOOKUP_CODE (+)
AND E.LOOKUP_TYPE (+) = 'UNIT'
AND E.LANGUAGE (+) = USERENV('LANG')
AND E.VIEW_APPLICATION_ID (+) = 275
AND DECODE(A.LOOKUP_CODE
, 'QU'
, E.MEANING
, A.MEANING) IS NOT NULL
AND DECODE(A.LOOKUP_CODE
, 'QU'
, PA_BUDGET_MATRIX.GET_QUANTITY_FLAG
, 'RC'
, PA_BUDGET_MATRIX.GET_RAW_COST_FLAG
, 'BC'
, PA_BUDGET_MATRIX.GET_BURDENED_COST_FLAG
, 'RE'
, PA_BUDGET_MATRIX.GET_REVENUE_FLAG ) = 'Y'
AND C.RESOURCE_ASSIGNMENT_ID(+) = B.RESOURCE_ASSIGNMENT_ID
AND C2.RESOURCE_ASSIGNMENT_ID (+) = B.RESOURCE_ASSIGNMENT_ID
AND C3.RESOURCE_ASSIGNMENT_ID (+) = B.RESOURCE_ASSIGNMENT_ID
AND C4.RESOURCE_ASSIGNMENT_ID (+)= B.RESOURCE_ASSIGNMENT_ID
AND C.START_DATE(+)= PA_BUDGET_MATRIX.GET_PRD1
AND C2.START_DATE(+)= PA_BUDGET_MATRIX.GET_PRD2
AND C3.START_DATE(+)= PA_BUDGET_MATRIX.GET_PRD3
AND C4.START_DATE(+)= PA_BUDGET_MATRIX.GET_PRD4
AND EXISTS (SELECT 'X'
FROM PA_BUDGET_LINES L
WHERE L.RESOURCE_ASSIGNMENT_ID = B.RESOURCE_ASSIGNMENT_ID
AND L.START_DATE BETWEEN PA_BUDGET_MATRIX.GET_PRD1
AND NVL(NVL(NVL(PA_BUDGET_MATRIX.GET_PRD4
, PA_BUDGET_MATRIX.GET_PRD3)
, PA_BUDGET_MATRIX.GET_PRD2)
, PA_BUDGET_MATRIX.GET_PRD1)) UNION ALL SELECT B.BUDGET_VERSION_ID
, B.TASK_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, B.RESOURCE_ASSIGNMENT_ID
, D.RESOURCE_LIST_MEMBER_ID
, D.RESOURCE_LIST_ID
, D.RESOURCE_ID
, D.ALIAS ALIAS
, B.UNIT_OF_MEASURE
, B.TRACK_AS_LABOR_FLAG
, A.LOOKUP_CODE
, DECODE(A.LOOKUP_CODE
, 'QU'
, E.MEANING
, A.MEANING)
, DECODE(A.LOOKUP_CODE
, 'RC'
, 2
, 'BC'
, 3
, 'QU'
, 1
, 'RE'
, 4)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, D.PARENT_MEMBER_ID
FROM FND_LOOKUP_VALUES A
, FND_LOOKUP_VALUES E
, PA_RESOURCE_LIST_MEMBERS D
, PA_RESOURCE_ASSIGNMENTS B
WHERE B.BUDGET_VERSION_ID = PA_BUDGET_MATRIX.GET_BUDGET_VERSION_ID
AND B.PROJECT_ID = PA_BUDGET_MATRIX.GET_PROJECT_ID
AND B.TASK_ID = PA_BUDGET_MATRIX.GET_TASK_ID
AND NVL(D.MIGRATION_CODE
, '-99') <> 'N'
AND 'BUDGET AMOUNT TYPES' = A.LOOKUP_TYPE(+)
AND A.LANGUAGE (+) = USERENV('LANG')
AND A.VIEW_APPLICATION_ID (+) = 275
AND B.RESOURCE_LIST_MEMBER_ID = D.RESOURCE_LIST_MEMBER_ID
AND B.UNIT_OF_MEASURE = E.LOOKUP_CODE (+)
AND E.LOOKUP_TYPE (+) = 'UNIT'
AND E.LANGUAGE (+) = USERENV('LANG')
AND E.VIEW_APPLICATION_ID (+) = 275
AND DECODE(A.LOOKUP_CODE
, 'QU'
, E.MEANING
, A.MEANING) IS NOT NULL
AND DECODE(A.LOOKUP_CODE
, 'QU'
, PA_BUDGET_MATRIX.GET_QUANTITY_FLAG
, 'RC'
, PA_BUDGET_MATRIX.GET_RAW_COST_FLAG
, 'BC'
, PA_BUDGET_MATRIX.GET_BURDENED_COST_FLAG
, 'RE'
, PA_BUDGET_MATRIX.GET_REVENUE_FLAG ) = 'Y'
AND NOT EXISTS (SELECT 'X'
FROM PA_BUDGET_LINES L
WHERE L.RESOURCE_ASSIGNMENT_ID = B.RESOURCE_ASSIGNMENT_ID
AND L.START_DATE BETWEEN PA_BUDGET_MATRIX.GET_PRD1
AND NVL(NVL(NVL(PA_BUDGET_MATRIX.GET_PRD4
, PA_BUDGET_MATRIX.GET_PRD3)
, PA_BUDGET_MATRIX.GET_PRD2)
, PA_BUDGET_MATRIX.GET_PRD1))

Columns

Name
BUDGET_VERSION_ID
TASK_ID
P1_AMT
P2_AMT
P3_AMT
P4_AMT
RESOURCE_ASSIGNMENT_ID
RESOURCE_LIST_MEMBER_ID
RESOURCE_LIST_ID
RESOURCE_ID
RESOURCE_NAME
UNIT_OF_MEASURE
TRACK_AS_LABOR_FLAG
AMT_TYPE
AMT_TYPE_DESC
SEQ_NO
DF_LONG_P1_1
DF_LONG_P1_2
DF_LONG_P2_1
DF_LONG_P2_2
DF_LONG_P3_1
DF_LONG_P3_2
DF_LONG_P4_1
DF_LONG_P4_2
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CHANGE_REASON_M
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE_P1
LAST_UPDATED_BY_P1
CREATION_DATE_P1
CREATED_BY_P1
LAST_UPDATE_LOGIN_P1
LAST_UPDATE_DATE_P2
LAST_UPDATED_BY_P2
CREATION_DATE_P2
CREATED_BY_P2
LAST_UPDATE_LOGIN_P2
LAST_UPDATE_DATE_P3
LAST_UPDATED_BY_P3
CREATION_DATE_P3
CREATED_BY_P3
LAST_UPDATE_LOGIN_P3
LAST_UPDATE_DATE_P4
LAST_UPDATED_BY_P4
CREATION_DATE_P4
CREATED_BY_P4
LAST_UPDATE_LOGIN_P4
PARENT_MEMBER_ID