[Home] [Help]
View: ICX_REQUESTER_LOV
View Text
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
Columns
Name |
FULL_NAME |
EMPLOYEE_ID |
WEB_USER_ID |
DELIVER_TO_LOCATION |
LOCATION_CODE |
ORGANIZATION_CODE |