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: PSPFV_COST_DIST_LINE_ADJUST

Product:	PSP - Labor Distribution
Description:	PSPFV_COST_DIST_LINE_ADJUST displays information regarding distribution lines created due to adjustments.
Implementation/DBA Data:	Not implemented in this database

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
, PAL.BATCH_NAME
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, '_LA:PAL.ORIGINAL_LINE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAH.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERSON_ID
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, '_KF:SQLGL:GL#:GCC1:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EFFORT_REPORT_ID
, PAL.VERSION_NUM
, PAL.SUMMARY_LINE_ID
, PAL.USER_DEFINED_FIELD
, PAL.ORIG_LINE_ID
, 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
, GL.NAME
, PAH.BUSINESS_GROUP_ID
, HOU3.NAME
, '_KF:SQLGL:GL#:GCC2:_CO'
, 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 PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_ALL_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PSP_ADJUSTMENT_LINES_HISTORY PAH
, PER_TIME_PERIODS PTP
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU3
, PA_TASKS PT
, PA_TASKS PT1
, PER_ALL_ASSIGNMENTS_F PAA
, GMS_AWARDS_ALL GAA
, GMS_AWARDS_ALL GAA1
, PA_PROJECTS_ALL PPA
, PA_PROJECTS_ALL PPA1
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, GL_SETS_OF_BOOKS GL
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.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID(+)
AND PAL.EXPENDITURE_ORGANIZATION_ID= HOU.ORGANIZATION_ID(+)
AND PAH.EXPENDITURE_ORGANIZATION_ID= HOU1.ORGANIZATION_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND PAH.TASK_ID = PT1.TASK_ID(+)
AND PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND ( PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PAH.AWARD_ID = GAA1.AWARD_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PAH.PROJECT_ID = PPA1.PROJECT_ID(+)
AND PAL.GL_CODE_COMBINATION_ID=GCC1.CODE_COMBINATION_ID(+)
AND PAH.GL_CODE_COMBINATION_ID=GCC2.CODE_COMBINATION_ID(+)
AND PAH.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_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
, PAL.BATCH_NAME
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, '_LA:PAL.ORIGINAL_LINE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAH.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERSON_ID
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, '_KF:SQLGL:GL#:GCC1:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EFFORT_REPORT_ID
, PAL.VERSION_NUM
, PAL.SUMMARY_LINE_ID
, PAL.USER_DEFINED_FIELD
, PAL.ORIG_LINE_ID
, 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
, GL.NAME
, PPG.BUSINESS_GROUP_ID
, HOU2.NAME
, '_KF:SQLGL:GL#:GCC2:_CO'
, 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 PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_ALL_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PSP_ADJUSTMENT_LINES_HISTORY PAH
, PSP_PRE_GEN_DIST_LINES_HISTORY PPG
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_TASKS PT
, PER_ALL_ASSIGNMENTS_F PAA
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_SETS_OF_BOOKS GL
, PA_TASKS PT1
, GMS_AWARDS_ALL GAA1
, PA_PROJECTS_ALL PPA1
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, PER_TIME_PERIODS PTP
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.EXPENDITURE_ORGANIZATION_ID= HOU.ORGANIZATION_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND PPG.TASK_ID = PT1.TASK_ID(+)
AND (PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PPG.AWARD_ID = GAA1.AWARD_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PPG.PROJECT_ID = PPA1.PROJECT_ID(+)
AND PPG.EXPENDITURE_ORGANIZATION_ID= HOU1.ORGANIZATION_ID(+)
AND PAL.TIME_PERIOD_ID=PTP.TIME_PERIOD_ID(+)
AND PAL.GL_CODE_COMBINATION_ID=GCC1.CODE_COMBINATION_ID(+)
AND PAH.GL_CODE_COMBINATION_ID=GCC2.CODE_COMBINATION_ID(+)
AND PPG.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID
AND PPG.BUSINESS_GROUP_ID=HOU2.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
, PAL.BATCH_NAME
, '_LA:PAL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, '_LA:PAL.ORIGINAL_LINE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:PAH.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:PAL.REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.PERSON_ID
, PAL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, '_KF:SQLGL:GL#:GCC1:_CO'
, PAL.PROJECT_ID
, PPA.NAME
, PAL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PAL.EXPENDITURE_TYPE
, PAL.TASK_ID
, PT.TASK_NAME
, PAL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PAL.EFFORT_REPORT_ID
, PAL.VERSION_NUM
, PAL.SUMMARY_LINE_ID
, PAL.USER_DEFINED_FIELD
, PAL.ORIG_LINE_ID
, 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
, '_KF:SQLGL:GL#:GCC2:_CO'
, 0
, NULL
, 0
, NULL
, NULL
, 0
, NULL
, 0
, NULL
FROM PSP_ADJUSTMENT_LINES PAL
, PSP_PAYROLL_CONTROLS PPC
, PER_ALL_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, PSP_ADJUSTMENT_LINES_HISTORY PAH
, HR_ALL_ORGANIZATION_UNITS HOU
, PA_TASKS PT
, PER_ALL_ASSIGNMENTS_F PAA
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, PER_TIME_PERIODS PTP
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.EXPENDITURE_ORGANIZATION_ID= HOU.ORGANIZATION_ID(+)
AND PAL.TASK_ID = PT.TASK_ID(+)
AND (PAL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAL.DISTRIBUTION_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PAL.AWARD_ID = GAA.AWARD_ID(+)
AND PAL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PAL.TIME_PERIOD_ID=PTP.TIME_PERIOD_ID(+)
AND PAL.GL_CODE_COMBINATION_ID=GCC1.CODE_COMBINATION_ID(+)
AND PAH.GL_CODE_COMBINATION_ID=GCC2.CODE_COMBINATION_ID(+)
AND '_SEC:PAL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ADJUSTMENT_LINE_ID
"_LA:DEBIT_CREDIT_FLAG"
"_LA:SOURCE_TYPE_FLAG"
SOURCE_CODE
DIST_LINE_ADJUST_BATCH_NAME
"_LA:ADJUSTMENT_LINE_STATUS"
"_LA:ORIGINAL_LINE_FLAG"
PERCENTAGE
ORIG_SOURCE_TYPE_FLAG
DISTRIBUTION_DATE
EFFECTIVE_DATE
DISTRIBUTION_AMOUNT
"_LA:STATUS_CODE"
SUSPENSE_ORG_ACCOUNT_ID
"_LA:REVERSAL_ENTRY_FLAG"
PERSON_ID
ASSIGNMENT_ID
ASSIGNMENT_NUMBER
ELEMENT_TYPE_ID
PAYROLL_CONTROL_ID
TIME_PERIOD_ID
TIME_PERIOD_NAME
"_KF:GL_ACCOUNT:CUR"
PROJECT_ID
PROJECT_NAME
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_ORGANIZATION_NAME
EXPENDITURE_TYPE
TASK_ID
TASK_NAME
AWARD_ID
AWARD_FULL_NAME
EFFORT_REPORT_ID
VERSION_NUMBER
SUMMARY_LINE_ID
USER_DEFINED_FIELD
ORIGINAL_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
PAYROLL_BATCH_NAME
PAYROLL_BATCH_STATUS_FLAG
EMPLOYEE_NUMBER
FIRST_NAME
LAST_NAME
ELEMENT_NAME
ORIGINAL_DISTRIBUTION_DATE
ORIGINAL_SET_OF_BOOKS
SET_OF_BOOKS_NAME
BUSINESS_GROUP_ID
BUSINESS_GRP_NAME
"_KF:GL_ACCOUNT:ORG"
ORIGINAL_PROJECT_ID
ORIGINAL_PROJECT_NAME
ORIGINAL_EXPEND_ORG_ID
ORIGINAL_EXPEND_ORG_NAME
ORIGINAL_EXPENDITURE_TYPE
ORIGINAL_TASK_ID
ORIGINAL_TASK_NAME
ORIGINAL_AWARD_ID
ORIGINAL_AWARD_FULL_NAME