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_GENERATED_DIST_HISTORIES

Product:	PSP - Labor Distribution
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.GL_PROJECT_FLAG
, PDL.DEFAULT_REASON_CODE
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.USER_DEFINED_FIELD
, PDL.ADJUSTMENT_BATCH_NAME
, PDL.SUMMARY_LINE_ID
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.REASON_CODE
, POA.START_DATE_ACTIVE
, POA.END_DATE_ACTIVE
, '_KF:SQLGL:GL#:GCC:_CO'
, POA.PROJECT_ID
, PPA.NAME
, POA.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, POA.EXPENDITURE_TYPE
, POA.TASK_ID
, PT.TASK_NAME
, POA.AWARD_ID
, GAA.AWARD_FULL_NAME
FROM PSP_DISTRIBUTION_LINES_HISTORY PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_ORGANIZATION_ACCOUNTS POA
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_SETS_OF_BOOKS GL
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.DEFAULT_ORG_ACCOUNT_ID = POA.ORGANIZATION_ACCOUNT_ID(+)
AND POA.PROJECT_ID = PPA.PROJECT_ID(+)
AND POA.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND POA.TASK_ID = PT.TASK_ID(+)
AND POA.AWARD_ID = GAA.AWARD_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PDL.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PDL.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND '_SEC:POA.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.GL_PROJECT_FLAG
, PDL.DEFAULT_REASON_CODE
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.USER_DEFINED_FIELD
, PDL.ADJUSTMENT_BATCH_NAME
, PDL.SUMMARY_LINE_ID
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.REASON_CODE
, POA.START_DATE_ACTIVE
, POA.END_DATE_ACTIVE
, '_KF:SQLGL:GL#:GCC:_CO'
, POA.PROJECT_ID
, PPA.NAME
, POA.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, POA.EXPENDITURE_TYPE
, POA.TASK_ID
, PT.TASK_NAME
, POA.AWARD_ID
, GAA.AWARD_FULL_NAME
FROM PSP_DISTRIBUTION_LINES_HISTORY PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_ORGANIZATION_ACCOUNTS POA
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_SETS_OF_BOOKS GL
, GL_CODE_COMBINATIONS GCC
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.SUSPENSE_ORG_ACCOUNT_ID = POA.ORGANIZATION_ACCOUNT_ID(+)
AND POA.PROJECT_ID = PPA.PROJECT_ID(+)
AND POA.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND POA.TASK_ID = PT.TASK_ID(+)
AND POA.AWARD_ID = GAA.AWARD_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PDL.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID
AND PDL.BUSINESS_GROUP_ID= HOU2.ORGANIZATION_ID
AND '_SEC:POA.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.GL_PROJECT_FLAG
, PDL.DEFAULT_REASON_CODE
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.USER_DEFINED_FIELD
, PDL.ADJUSTMENT_BATCH_NAME
, PDL.SUMMARY_LINE_ID
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.REASON_CODE
, PSL.SCHEDULE_BEGIN_DATE
, PSL.SCHEDULE_END_DATE
, '_KF:SQLGL:GL#:GCC:_CO'
, PSL.PROJECT_ID
, PPA.NAME
, PSL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PSL.EXPENDITURE_TYPE
, PSL.TASK_ID
, PT.TASK_NAME
, PSL.AWARD_ID
, GAA.AWARD_FULL_NAME
FROM PSP_DISTRIBUTION_LINES_HISTORY PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_SCHEDULE_LINES PSL
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_SETS_OF_BOOKS GL
, GL_CODE_COMBINATIONS GCC
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.SCHEDULE_LINE_ID = PSL.SCHEDULE_LINE_ID(+)
AND PSL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PSL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND PSL.TASK_ID = PT.TASK_ID(+)
AND PSL.AWARD_ID = GAA.AWARD_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PDL.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND PDL.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND '_SEC:PSL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.GL_PROJECT_FLAG
, PDL.DEFAULT_REASON_CODE
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.USER_DEFINED_FIELD
, PDL.ADJUSTMENT_BATCH_NAME
, PDL.SUMMARY_LINE_ID
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.REASON_CODE
, PDS.SCHEDULE_BEGIN_DATE
, PDS.SCHEDULE_END_DATE
, '_KF:SQLGL:GL#:GCC:_CO'
, PDS.PROJECT_ID
, PPA.NAME
, PDS.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PDS.EXPENDITURE_TYPE
, PDS.TASK_ID
, PT.TASK_NAME
, PDS.AWARD_ID
, GAA.AWARD_FULL_NAME
FROM PSP_DISTRIBUTION_LINES_HISTORY PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_DEFAULT_LABOR_SCHEDULES PDS
, GMS_AWARDS_ALL GAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_SETS_OF_BOOKS GL
, GL_CODE_COMBINATIONS GCC
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.ORG_SCHEDULE_ID = PDS.ORG_SCHEDULE_ID(+)
AND PDS.PROJECT_ID = PPA.PROJECT_ID(+)
AND PDS.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND PDS.TASK_ID = PT.TASK_ID(+)
AND PDS.AWARD_ID = GAA.AWARD_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PDL.BUSINESS_GROUP_ID= HOU2.ORGANIZATION_ID
AND PDL.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID
AND '_SEC:PDS.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
DISTRIBUTION_LINE_ID
GL_OR_PROJECT
DEFAULT_ACCT_REASON_CODE
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
BUSINESS_GROUP_ID
BUSINESS_GRP_NAME
DISTRIBUTION_DATE
EFFECTIVE_DATE
DISTRIBUTION_AMOUNT
"_LA:STATUS_CODE"
SUSPENSE_ACCOUNT_REASON
"_LA:INCLUDE_IN_EFFORT_REPORT"
"_LA:REVERSAL_ENTRY_FLAG"
USER_DEFINED_FIELD
ADJUSTMENT_BATCH_NAME
SUMMARY_LINE_ID
EFFORT_REPORT_ID
VERSION_NUMBER
PAYROLL_SUB_LINE_ID
SUBLINE_START_DATE
SUBLINE_END_DATE
SUBLINE_AMOUNT
SUBLINE_DAILY_RATE
SUBLINE_REASON_CODE
SCHEDULE_BEGIN_DATE
SCHEDULE_END_DATE
"_KF:GL_ACCOUNT"
PROJECT_ID
PROJECT_NAME
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_ORGANIZATION_NAME
EXPENDITURE_TYPE
TASK_ID
TASK_NAME
AWARD_ID
AWARD_FULL_NAME