DBA Data[Home] [Help]

VIEW: APPS.IGWFV_GRANT_PRPSL_ROUTING_LIST

Source

View Text - Preformatted

SELECT ORGMAPS.DESCRIPTION, HR.name, ORGMAPS.START_DATE_ACTIVE, ORGMAPS.END_DATE_ACTIVE, ORGMAPS.MAP_ID, ORGMAPS.ORGANIZATION_ID, ORGMAPS.ORG_ID, ORGMAPS.LAST_UPDATE_DATE, ORGMAPS.LAST_UPDATED_BY, ORGMAPS.CREATION_DATE, ORGMAPS.CREATED_BY from IGW_ORG_MAPS_ALL ORGMAPS, HR_ALL_ORGANIZATION_UNITS HR WHERE HR.ORGANIZATION_ID = ORGMAPS.ORGANIZATION_ID with read only
View Text - HTML Formatted

SELECT ORGMAPS.DESCRIPTION
, HR.NAME
, ORGMAPS.START_DATE_ACTIVE
, ORGMAPS.END_DATE_ACTIVE
, ORGMAPS.MAP_ID
, ORGMAPS.ORGANIZATION_ID
, ORGMAPS.ORG_ID
, ORGMAPS.LAST_UPDATE_DATE
, ORGMAPS.LAST_UPDATED_BY
, ORGMAPS.CREATION_DATE
, ORGMAPS.CREATED_BY
FROM IGW_ORG_MAPS_ALL ORGMAPS
, HR_ALL_ORGANIZATION_UNITS HR
WHERE HR.ORGANIZATION_ID = ORGMAPS.ORGANIZATION_ID WITH READ ONLY