VIEW: APPS.PSP_SCHEDULES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)