View: GML_GRP_RCV_ERV

Product:	GML - Process Manufacturing Logistics
Description:	View of Group Id and Organization Information for ERES
Implementation/DBA Data:	APPS.GML_GRP_RCV_ERV

View Text

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

Columns