Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.DEFAULT_REASON_CODE
, PDL.GL_PROJECT_FLAG
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.PRE_DISTRIBUTION_RUN_FLAG
, PDL.USER_DEFINED_FIELD
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.SUMMARY_LINE_ID
, PDL.SCHEDULE_LINE_ID
, PDL.ORG_SCHEDULE_ID
, PDL.ELEMENT_ACCOUNT_ID
, PDL.PAYROLL_SUB_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_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 PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_ORGANIZATION_ACCOUNTS POA
, PA_PROJECTS_ALL PPA
, GMS_AWARDS_ALL GAA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_CODE_COMBINATIONS GCC
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.DEFAULT_ORG_ACCOUNT_ID = POA.ORGANIZATION_ACCOUNT_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_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.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND PDL.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND '_SEC:POA.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL UNION SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.DEFAULT_REASON_CODE
, PDL.GL_PROJECT_FLAG
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.PRE_DISTRIBUTION_RUN_FLAG
, PDL.USER_DEFINED_FIELD
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.SUMMARY_LINE_ID
, PDL.SCHEDULE_LINE_ID
, PDL.ORG_SCHEDULE_ID
, PDL.ELEMENT_ACCOUNT_ID
, PDL.PAYROLL_SUB_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_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 PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_ORGANIZATION_ACCOUNTS POA
, PA_PROJECTS_ALL PPA
, GMS_AWARDS_ALL GAA
, 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.SUSPENSE_ORG_ACCOUNT_ID = POA.ORGANIZATION_ACCOUNT_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_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.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.DEFAULT_REASON_CODE
, PDL.GL_PROJECT_FLAG
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.PRE_DISTRIBUTION_RUN_FLAG
, PDL.USER_DEFINED_FIELD
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.SUMMARY_LINE_ID
, PDL.SCHEDULE_LINE_ID
, PDL.ORG_SCHEDULE_ID
, PDL.ELEMENT_ACCOUNT_ID
, PDL.PAYROLL_SUB_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_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 PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_SCHEDULE_LINES PSL
, PA_PROJECTS_ALL PPA
, GMS_AWARDS_ALL GAA
, 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.SCHEDULE_LINE_ID = PSL.SCHEDULE_LINE_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_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.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.DEFAULT_REASON_CODE
, PDL.GL_PROJECT_FLAG
, PDL.SET_OF_BOOKS_ID
, GL.NAME
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.PRE_DISTRIBUTION_RUN_FLAG
, PDL.USER_DEFINED_FIELD
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.SUMMARY_LINE_ID
, PDL.SCHEDULE_LINE_ID
, PDL.ORG_SCHEDULE_ID
, PDL.ELEMENT_ACCOUNT_ID
, PDL.PAYROLL_SUB_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_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 PDL
, PSP_PAYROLL_SUB_LINES PPS
, PSP_DEFAULT_LABOR_SCHEDULES PDS
, PA_PROJECTS_ALL PPA
, GMS_AWARDS_ALL GAA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_CODE_COMBINATIONS GCC
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE PDL.PAYROLL_SUB_LINE_ID = PPS.PAYROLL_SUB_LINE_ID
AND PDL.ORG_SCHEDULE_ID = PDS.ORG_SCHEDULE_ID(+)
AND PDL.AUTO_GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_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.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