View: CLN_ITEMMST_INVENTORY_ORGS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available inventory organizations
Implementation/DBA Data:	APPS.CLN_ITEMMST_INVENTORY_ORGS_V

View Text

SELECT ORG.ORGANIZATION_ID
, PAR.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, DECODE(PAR.ORGANIZATION_ID
, PAR.MASTER_ORGANIZATION_ID
, 'MASTER'
, 'ORG') ORG_LEVEL
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, MTL_PARAMETERS PAR
WHERE ORG.ORGANIZATION_ID = PAR.ORGANIZATION_ID
AND ORG.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PAR.ORGANIZATION_ID = PAR.MASTER_ORGANIZATION_ID

Columns