[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 |