View: PSPFV_DIST_ADJUST_HISTORIES

View Text

SELECT PAL.ADJUSTMENT_LINE_ID
, '_LA:PAL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:PAL.SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PAL.SOURCE_CODE
, PPS.DESCRIPTION
, PAL.SET_OF_BOOKS_ID
, GSB.NAME
, PAL.BUSINESS_GROUP_ID
, HOU2.NAME
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.ORIG_LINE_ID
, PAL.ORIGINAL_LINE_FLAG
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_REASON_CODE
, '_LA:PAL.INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.USER_DEFINED_FIELD
, PAL.BATCH_NAME
, PAL.SUMMARY_LINE_ID
, PAL.EFFORT_REPORT_ID
, PAL.PERSON_ID
, PAL.VERSION_NUM
, '_KF:SQLGL:GL#:GCC:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PAL.LAST_UPDATE_DATE
, PAL.LAST_UPDATED_BY
, PAL.CREATED_BY
, PAL.CREATION_DATE
, PPC.BATCH_NAME
, PPC.STATUS_CODE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PET.ELEMENT_NAME
, PAH.DISTRIBUTION_DATE
, PAH.SET_OF_BOOKS_ID
, GSB1.NAME
, PAH.BUSINESS_GROUP_ID
, HOU3.NAME
, PAH.GL_CODE_COMBINATION_ID
, PAH.PROJECT_ID
, PPA1.NAME
, PAH.EXPENDITURE_ORGANIZATION_ID
, HOU1.NAME
, PAH.EXPENDITURE_TYPE
, PAH.TASK_ID
, PT1.TASK_NAME
, PAH.AWARD_ID
, GAA1.AWARD_FULL_NAME
FROM PSP_ADJUSTMENT_LINES_HISTORY PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_ALL_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PSP_ADJUSTMENT_LINES_HISTORY PAH
, PA_PROJECTS_ALL PPA
, GL_SETS_OF_BOOKS GSB
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, PER_TIME_PERIODS PTP
, PER_ALL_ASSIGNMENTS_F PAA
, GL_SETS_OF_BOOKS GSB1
, PA_PROJECTS_ALL PPA1
, HR_ALL_ORGANIZATION_UNITS HOU1
, PA_TASKS PT1
, GMS_AWARDS_ALL GAA1
, PSP_PAYROLL_SOURCES PPS
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS HOU2
, HR_ALL_ORGANIZATION_UNITS HOU3
WHERE PAL.PAYROLL_CONTROL_ID = PPC.PAYROLL_CONTROL_ID
AND (PAL.PERSON_ID = PPF.PERSON_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND (PAL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE)
AND PAL.ORIG_LINE_ID = PAH.ADJUSTMENT_LINE_ID(+)
AND PAL.ORIG_SOURCE_TYPE = 'A'
AND PAL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PAL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND (PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND (PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE))
AND PAL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID(+)
AND PAH.SET_OF_BOOKS_ID = GSB1.SET_OF_BOOKS_ID(+)
AND PAH.PROJECT_ID = PPA1.PROJECT_ID(+)
AND PAH.TASK_ID = PT1.TASK_ID(+)
AND PAH.AWARD_ID = GAA1.AWARD_ID(+)
AND PAH.EXPENDITURE_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+)
AND PAL.SOURCE_TYPE=PPS.SOURCE_TYPE
AND PAL.SOURCE_CODE=PPS.SOURCE_CODE
AND PAL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PAL.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND PAH.BUSINESS_GROUP_ID=HOU3.ORGANIZATION_ID
AND '_SEC:PAL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PAL.ADJUSTMENT_LINE_ID
, '_LA:PAL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:PAL.SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PAL.SOURCE_CODE
, PPS.DESCRIPTION
, PAL.SET_OF_BOOKS_ID
, GSB.NAME
, PAL.BUSINESS_GROUP_ID
, HOU2.NAME
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.ORIG_LINE_ID
, PAL.ORIGINAL_LINE_FLAG
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_REASON_CODE
, '_LA:PAL.INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.USER_DEFINED_FIELD
, PAL.BATCH_NAME
, PAL.SUMMARY_LINE_ID
, PAL.EFFORT_REPORT_ID
, PAL.PERSON_ID
, PAL.VERSION_NUM
, '_KF:SQLGL:GL#:GCC:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PAL.LAST_UPDATE_DATE
, PAL.LAST_UPDATED_BY
, PAL.CREATED_BY
, PAL.CREATION_DATE
, PPC.BATCH_NAME
, PPC.STATUS_CODE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PET.ELEMENT_NAME
, PPG.DISTRIBUTION_DATE
, PPG.SET_OF_BOOKS_ID
, GSB1.NAME
, PPG.BUSINESS_GROUP_ID
, HOU3.NAME
, PPG.GL_CODE_COMBINATION_ID
, PPG.PROJECT_ID
, PPA1.NAME
, PPG.EXPENDITURE_ORGANIZATION_ID
, HOU1.NAME
, PPG.EXPENDITURE_TYPE
, PPG.TASK_ID
, PT1.TASK_NAME
, PPG.AWARD_ID
, GAA1.AWARD_FULL_NAME
FROM PSP_ADJUSTMENT_LINES_HISTORY PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PSP_PRE_GEN_DIST_LINES_HISTORY PPG
, PA_PROJECTS_ALL PPA
, GL_SETS_OF_BOOKS GSB
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, PER_TIME_PERIODS PTP
, PER_ALL_ASSIGNMENTS_F PAA
, PA_PROJECTS_ALL PPA1
, GL_SETS_OF_BOOKS GSB1
, HR_ALL_ORGANIZATION_UNITS HOU1
, PA_TASKS PT1
, GMS_AWARDS_ALL GAA1
, PSP_PAYROLL_SOURCES PPS
, HR_ALL_ORGANIZATION_UNITS HOU2
, HR_ALL_ORGANIZATION_UNITS HOU3
, GL_CODE_COMBINATIONS GCC
WHERE PAL.PAYROLL_CONTROL_ID = PPC.PAYROLL_CONTROL_ID
AND (PAL.PERSON_ID = PPF.PERSON_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND (PAL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE)
AND PAL.ORIG_LINE_ID = PPG.PRE_GEN_DIST_LINE_ID(+)
AND PAL.ORIG_SOURCE_TYPE = 'P'
AND PAL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PAL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND (PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND (PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE))
AND PAL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID(+)
AND PPG.SET_OF_BOOKS_ID = GSB1.SET_OF_BOOKS_ID
AND PPG.PROJECT_ID = PPA1.PROJECT_ID(+)
AND PPG.TASK_ID = PT1.TASK_ID(+)
AND PPG.AWARD_ID = GAA1.AWARD_ID(+)
AND PPG.EXPENDITURE_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+)
AND PAL.SOURCE_TYPE=PPS.SOURCE_TYPE
AND PAL.SOURCE_CODE=PPS.SOURCE_CODE
AND PAL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PAL.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND PPG.BUSINESS_GROUP_ID=HOU3.ORGANIZATION_ID
AND '_SEC:PAL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PAL.ADJUSTMENT_LINE_ID
, '_LA:PAL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:PAL.SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PAL.SOURCE_CODE
, PPS.DESCRIPTION
, PAL.SET_OF_BOOKS_ID
, GSB.NAME
, PAL.BUSINESS_GROUP_ID
, HOU2.NAME
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.ORIG_LINE_ID
, PAL.ORIGINAL_LINE_FLAG
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_REASON_CODE
, '_LA:PAL.INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.USER_DEFINED_FIELD
, PAL.BATCH_NAME
, PAL.SUMMARY_LINE_ID
, PAL.EFFORT_REPORT_ID
, PAL.PERSON_ID
, PAL.VERSION_NUM
, '_KF:SQLGL:GL#:GCC:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PAL.LAST_UPDATE_DATE
, PAL.LAST_UPDATED_BY
, PAL.CREATED_BY
, PAL.CREATION_DATE
, PPC.BATCH_NAME
, PPC.STATUS_CODE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PET.ELEMENT_NAME
, TO_DATE(NULL)
, 0
, NULL
, 0
, NULL
, 0
, 0
, NULL
, 0
, NULL
, NULL
, 0
, NULL
, 0
, NULL
FROM PSP_ADJUSTMENT_LINES_HISTORY PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PA_PROJECTS_ALL PPA
, GL_SETS_OF_BOOKS GSB
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, PER_TIME_PERIODS PTP
, PER_ALL_ASSIGNMENTS_F PAA
, PSP_PAYROLL_SOURCES PPS
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE PAL.PAYROLL_CONTROL_ID = PPC.PAYROLL_CONTROL_ID
AND (PAL.PERSON_ID = PPF.PERSON_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND (PAL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE)
AND (PAL.ORIG_SOURCE_TYPE = 'D' OR NVL(PAL.ORIG_SOURCE_TYPE
, ' ') = ' ')
AND PAL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PAL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND (PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND (PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE))
AND PAL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID(+)
AND PAL.SOURCE_TYPE=PPS.SOURCE_TYPE
AND PAL.SOURCE_CODE=PPS.SOURCE_CODE
AND PAL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PAL.BUSINESS_GROUP_ID= HOU2.ORGANIZATION_ID
AND '_SEC:PAL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns