[Home] [Help]
View: PSP_SCHEDULES_V
Product: | PSP - Labor Distribution |
Description: | Shows schedules for an employee assignment |
Implementation/DBA Data: |
APPS.PSP_SCHEDULES_V
|
View Text
SELECT S.ROWID ROW_ID
, PER.PERSON_ID
, A.ASSIGNMENT_ID
, A.BEGIN_DATE
, A.END_DATE
, S.FTE
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.CREATED_BY
, S.CREATION_DATE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_ASSIGNMENTS_V A
, PSP_SCHEDULES S
, PER_PEOPLE_F PER
WHERE PER.PERSON_ID = A.PERSON_ID
AND A.ASSIGNMENT_ID = S.ASSIGNMENT_ID(+)
Columns
Name |
ROW_ID |
PERSON_ID |
ASSIGNMENT_ID |
BEGIN_DATE |
END_DATE |
FTE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |