[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | The view was not picking up the system_linkage_function for expenditure types that do not have a default system linkage_function defined in pa_expenditure_types table. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ALIAS
, A.SHARED_FLAG
, A.BTN_NUMBER
, A.BTN_TEXT
, A.BTN_VISUAL_ATTRIBUTE
, DECODE(A.PROJECT_ID
, NULL
, NULL
, P.SEGMENT1)
, DECODE(A.PROJECT_ID
, NULL
, NULL
, P.NAME)
, DECODE(A.TASK_ID
, NULL
, NULL
, T.TASK_NUMBER)
, DECODE(A.TASK_ID
, NULL
, NULL
, T.TASK_NAME)
, T.BILLABLE_FLAG
, A.EXPENDITURE_TYPE
, DECODE(A.EXPENDITURE_TYPE
, NULL
, NULL
, ET.UNIT_OF_MEASURE)
, A.SYSTEM_LINKAGE_FUNCTION
, DECODE(A.EXPENDITURE_TYPE
, NULL
, NULL
, SL.MEANING)
, A.COMMENTS
, A.PROJECT_ID
, A.TASK_ID
, A.PERSON_ID
FROM PA_EXPENDITURE_TYPES ET
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPEND_ALIASES A
, PA_SYSTEM_LINKAGES SL
WHERE A.SYSTEM_LINKAGE_FUNCTION = SL.FUNCTION(+)
AND A.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE(+)
AND A.TASK_ID = T.TASK_ID(+)
AND A.PROJECT_ID = P.PROJECT_ID(+)