Product: | PSP - Labor Distribution |
---|---|
Description: | Based on PSP_REP_DIST_PRJ_V and used in the Distribution History of Employees by Award report |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.SUSPENSE_ORG_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'SUSP' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ORGANIZATION_ACCOUNTS B
WHERE A.SUSPENSE_ORG_ACCOUNT_ID = B.ORGANIZATION_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.DEFAULT_ORG_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'DEF' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ORGANIZATION_ACCOUNTS B
WHERE A.DEFAULT_ORG_ACCOUNT_ID = B.ORGANIZATION_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.ELEMENT_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'EL_TYPE' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ELEMENT_TYPE_ACCOUNTS B
WHERE A.ELEMENT_ACCOUNT_ID = B.ELEMENT_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.ORG_SCHEDULE_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'LABOR' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_DEFAULT_LABOR_SCHEDULES B
WHERE A.ORG_SCHEDULE_ID = B.ORG_SCHEDULE_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.SCHEDULE_LINE_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'SCH_LINE' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_SCHEDULE_LINES B
WHERE A.SCHEDULE_LINE_ID = B.SCHEDULE_LINE_ID