[Home] [Help]
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
Name |
GROUP_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |