VIEW: APPS.GML_GRP_RCV_ERV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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