VIEW: APPS.PA_BUDGET_MATRIX_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))