SELECT DISTINCT r.GROUP_ID GROUP_ID, mp.organization_code organization_code, h.NAME organization_name FROM rcv_transactions_interface r, hr_all_organization_units h, mtl_parameters mp Where r.to_organization_id = h.organization_id AND h.organization_id = mp.organization_id
SELECT DISTINCT R.GROUP_ID GROUP_ID
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, H.NAME ORGANIZATION_NAME
FROM RCV_TRANSACTIONS_INTERFACE R
, HR_ALL_ORGANIZATION_UNITS H
, MTL_PARAMETERS MP
WHERE R.TO_ORGANIZATION_ID = H.ORGANIZATION_ID
AND H.ORGANIZATION_ID = MP.ORGANIZATION_ID
|
|
|