[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 |
APPS.IGW_ORG_MAP_DETAILS_V