View: PSP_REP_DIST_ORG_V

View Text

SELECT B.PERSON_ID
, B.ASSIGNMENT_ID
, B.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, (D.DISTRIBUTION_AMOUNT)
, D.DISTRIBUTION_DATE
, D.SUSPENSE_ORG_ACCOUNT_ID
, D.DEFAULT_ORG_ACCOUNT_ID
, D.ELEMENT_ACCOUNT_ID
, D.ORG_SCHEDULE_ID
, D.SCHEDULE_LINE_ID
, I.PERIOD_NAME
, H.ORGANIZATION_ID
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_PAYROLL_CONTROLS A
, PSP_PAYROLL_LINES B
, PSP_PAYROLL_SUB_LINES C
, PSP_DISTRIBUTION_LINES_HISTORY D
, PER_TIME_PERIODS I
, PER_ASSIGNMENTS_F F
, HR_ORGANIZATION_UNITS H
WHERE B.ASSIGNMENT_ID = F.ASSIGNMENT_ID
AND F.ORGANIZATION_ID = H.ORGANIZATION_ID
AND A.PAYROLL_CONTROL_ID = B.PAYROLL_CONTROL_ID
AND B.PAYROLL_LINE_ID = C.PAYROLL_LINE_ID
AND C.PAYROLL_SUB_LINE_ID = D.PAYROLL_SUB_LINE_ID
AND (D.DISTRIBUTION_DATE BETWEEN I.START_DATE
AND I.END_DATE)
AND ((NVL(D.SUSPENSE_ORG_ACCOUNT_ID
, 0) <>0
AND EXISTS(SELECT 'X'
FROM PSP_ORGANIZATION_ACCOUNTS SOA
WHERE D.SUSPENSE_ORG_ACCOUNT_ID = SOA.ORGANIZATION_ACCOUNT_ID
AND (SOA.PROJECT_ID IS NOT NULL OR SOA.GL_CODE_COMBINATION_ID IS NOT NULL))) OR (NVL(D.SUSPENSE_ORG_ACCOUNT_ID
, 0) = 0
AND ((NVL(D.DEFAULT_ORG_ACCOUNT_ID
, 0) <>0
AND EXISTS(SELECT 'X'
FROM PSP_ORGANIZATION_ACCOUNTS DOA
WHERE D.DEFAULT_ORG_ACCOUNT_ID= DOA.ORGANIZATION_ACCOUNT_ID
AND (DOA.PROJECT_ID IS NOT NULL OR DOA.GL_CODE_COMBINATION_ID IS NOT NULL))) OR (NVL(D.ELEMENT_ACCOUNT_ID
, 0) <> 0
AND EXISTS(SELECT 'X'
FROM PSP_ELEMENT_TYPE_ACCOUNTS ETA
WHERE D.ELEMENT_ACCOUNT_ID = ETA.ELEMENT_ACCOUNT_ID
AND ETA.PROJECT_ID IS NOT NULL)) OR (NVL(D.SCHEDULE_LINE_ID
, 0) <> 0
AND EXISTS(SELECT 'X'
FROM PSP_SCHEDULE_LINES SCL
WHERE D.SCHEDULE_LINE_ID = SCL.SCHEDULE_LINE_ID
AND (SCL.PROJECT_ID IS NOT NULL OR SCL.GL_CODE_COMBINATION_ID IS NOT NULL))) OR (NVL(D.ORG_SCHEDULE_ID
, 0) <> 0
AND EXISTS(SELECT 'X'
FROM PSP_DEFAULT_LABOR_SCHEDULES DLS
WHERE D.ORG_SCHEDULE_ID = DLS.ORG_SCHEDULE_ID
AND (DLS.PROJECT_ID IS NOT NULL OR DLS.GL_CODE_COMBINATION_ID IS NOT NULL))))))

Columns