[Home] [Help]
View: PSP_REP_SUSP_WARN_V
Product: | PSP - Labor Distribution |
Description: | No longer being used in Oracle Labor Distribution. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, D.ORGANIZATION_ID
, B.SCHEDULE_HIERARCHY_ID
, B.ELEMENT_TYPE_ID
, C.SCHEDULE_LINE_ID
, C.SCHEDULE_BEGIN_DATE
, C.SCHEDULE_END_DATE
, C.SCHEDULE_PERCENT
FROM PSP_SCHEDULES A
, PSP_SCHEDULE_HIERARCHY B
, PSP_SCHEDULE_LINES C
, PER_ASSIGNMENTS_F D
, PSP_ORGANIZATION_ACCOUNTS E
WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID
AND B.SCHEDULE_HIERARCHY_ID = C.SCHEDULE_HIERARCHY_ID
AND A.PERSON_ID = D.PERSON_ID
AND D.PRIMARY_FLAG = 'Y' GROUP BY A.PERSON_ID
, A.ASSIGNMENT_ID
, B.SCHEDULE_HIERARCHY_ID
, C.SCHEDULE_LINE_ID
, C.SCHEDULE_BEGIN_DATE
, C.SCHEDULE_END_DATE
, C.SCHEDULE_PERCENT
, D.ORGANIZATION_ID
, B.ELEMENT_TYPE_ID
Columns
Name |
PERSON_ID |
ASSIGNMENT_ID |
ORGANIZATION_ID |
SCHEDULE_HIERARCHY_ID |
ELEMENT_TYPE_ID |
SCHEDULE_LINE_ID |
SCHEDULE_BEGIN_DATE |
SCHEDULE_END_DATE |
SCHEDULE_PERCENT |