SELECT IPRVV.FULL_NAME , IPRVV.EMPLOYEE_ID , IPRVV.WEB_USER_ID , IPRVV.LOCATION_CODE||' ('||OOD.ORGANIZATION_CODE||')' , IPRVV.LOCATION_CODE , OOD.ORGANIZATION_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD, ICX_PO_REQUESTOR_VAL_V IPRVV WHERE IPRVV.LOCATION_ORGANIZATION_ID = OOD.ORGANIZATION_ID
SELECT IPRVV.FULL_NAME
, IPRVV.EMPLOYEE_ID
, IPRVV.WEB_USER_ID
, IPRVV.LOCATION_CODE||' ('||OOD.ORGANIZATION_CODE||')'
, IPRVV.LOCATION_CODE
, OOD.ORGANIZATION_CODE
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, ICX_PO_REQUESTOR_VAL_V IPRVV
WHERE IPRVV.LOCATION_ORGANIZATION_ID = OOD.ORGANIZATION_ID
|
|
|