[Home] [Help]
View: PSP_DISTRIBUTION_COMBO_V
| Product: | PSP - Labor Distribution |
|---|
| Description: | Based on PSP_DISTRIBUTION_LINES_HISTORY, PSP_PRE_GEN_DIST_LINES_HISTORY, and PSP_ADJUSTMENT_LINES_HISTORY tables |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT L.PERSON_ID
, L.ASSIGNMENT_ID
, L.ELEMENT_TYPE_ID
, D.DISTRIBUTION_DATE
, NVL(D.DISTRIBUTION_AMOUNT
, 0) DISTRIBUTION_AMOUNT
, D.DISTRIBUTION_LINE_ID
, D.EFFORT_REPORT_ID
, D.VERSION_NUM
, D.STATUS_CODE
, 'DISTRIBUTION_LINES_HISTORY' SOURCE
, D.BUSINESS_GROUP_ID
, D.SET_OF_BOOKS_ID
FROM PSP_DISTRIBUTION_LINES_HISTORY D
, PSP_PAYROLL_SUB_LINES S
, PSP_PAYROLL_LINES L
WHERE D.PAYROLL_SUB_LINE_ID = S.PAYROLL_SUB_LINE_ID
AND S.PAYROLL_LINE_ID = L.PAYROLL_LINE_ID
AND NVL(INCLUDE_IN_ER_FLAG
, 'Y') = 'Y'
AND NVL(REVERSAL_ENTRY_FLAG
, 'N') = 'N' UNION SELECT PERSON_ID
, ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, DISTRIBUTION_DATE
, NVL(DISTRIBUTION_AMOUNT
, 0)
, PRE_GEN_DIST_LINE_ID
, EFFORT_REPORT_ID
, VERSION_NUM
, STATUS_CODE
, 'PRE_GEN_DIST_LINES_HISTORY'
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_PRE_GEN_DIST_LINES_HISTORY
WHERE NVL(INCLUDE_IN_ER_FLAG
, 'Y') = 'Y'
AND NVL(REVERSAL_ENTRY_FLAG
, 'N') = 'N' UNION SELECT PERSON_ID
, ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, DISTRIBUTION_DATE
, NVL(DISTRIBUTION_AMOUNT
, 0)
, ADJUSTMENT_LINE_ID
, EFFORT_REPORT_ID
, VERSION_NUM
, STATUS_CODE
, 'ADJUSTMENT_LINES_HISTORY'
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_ADJUSTMENT_LINES_HISTORY
WHERE NVL(INCLUDE_IN_ER_FLAG
, 'Y') = 'Y'
AND NVL(REVERSAL_ENTRY_FLAG
, 'N') = 'N'
Columns
| Name |
| PERSON_ID |
| ASSIGNMENT_ID |
| ELEMENT_TYPE_ID |
| DISTRIBUTION_DATE |
| DISTRIBUTION_AMOUNT |
| DISTRIBUTION_LINE_ID |
| EFFORT_REPORT_ID |
| VERSION_NUM |
| STATUS_CODE |
| SOURCE |
| BUSINESS_GROUP_ID |
| SET_OF_BOOKS_ID |