View: PSPFV_EFFORT_REPORT_DETAILS

View Text

SELECT PED.EFFORT_REPORT_ID
, PED.VERSION_NUM
, PED.EFFORT_REPORT_LINE_NUM
, PED.TOTAL_AMOUNT
, PED.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PED.ELEMENT_TYPE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PED.PROJECT_ID
, PPA.NAME
, PED.TASK_ID
, PAT.TASK_NAME
, PED.AWARD_ID
, GAA.AWARD_FULL_NAME
, PED.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PED.EXPENDITURE_TYPE
, PED.LAST_UPDATE_DATE
, PED.LAST_UPDATED_BY
, PED.CREATED_BY
, PED.CREATION_DATE
, PER.VERSION_CREATION_DATE
, PER.MESSAGE_ID
, PER.REPORT_COMMENT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PER.TEMPLATE_ID
, PERT.TEMPLATE_NAME
, PER.PREV_EFFORT_REPORT_ID
, PET.ELEMENT_NAME
FROM PSP_EFFORT_REPORT_DETAILS PED
, PSP_EFFORT_REPORTS PER
, PAY_ELEMENT_TYPES_F PET
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PAT
, HR_ALL_ORGANIZATION_UNITS HOU
, PSP_EFFORT_REPORT_TEMPLATES PERT
, PER_ALL_ASSIGNMENTS_F PAA
, GL_CODE_COMBINATIONS GCC
WHERE PED.EFFORT_REPORT_ID = PER.EFFORT_REPORT_ID
AND PED.VERSION_NUM = PER.VERSION_NUM
AND (PED.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PER.VERSION_CREATION_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE)
AND PED.TASK_ID=PAT.TASK_ID(+)
AND PED.EXPENDITURE_ORGANIZATION_ID=HOU.ORGANIZATION_ID(+)
AND PED.AWARD_ID=GAA.AWARD_ID (+)
AND PED.PROJECT_ID=PPA.PROJECT_ID(+)
AND PER.TEMPLATE_ID=PERT.TEMPLATE_ID(+)
AND (PED.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID
AND PER.VERSION_CREATION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PED.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND '_SEC:PED.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns