[Home] [Help]
View: IGW_ORG_MAP_DETAILS_V
View Text
SELECT MPDTLS.ROWID
, MPDTLS.MAP_ID
, MPDTLS.STOP_ID
, PPX.FULL_NAME
, MPDTLS.USER_NAME
, MPDTLS.APPROVER_TYPE
, MPDTLS.LAST_UPDATE_DATE
, MPDTLS.LAST_UPDATED_BY
, MPDTLS.CREATION_DATE
, MPDTLS.CREATED_BY
, MPDTLS.LAST_UPDATE_LOGIN
FROM IGW_ORG_MAP_DETAILS MPDTLS
, PER_PEOPLE_X PPX
, FND_USER FU
WHERE FU.EMPLOYEE_ID = PPX.PERSON_ID
AND FU.USER_NAME = MPDTLS.USER_NAME
Columns
Name |
ROW_ID |
MAP_ID |
STOP_ID |
PERSON_NAME |
USER_NAME |
APPROVER_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |