Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | An Integration Toolkit view supporting information regarding inventory organizations |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.ORGANIZATION_ID
, P.ORGANIZATION_CODE
, HOU.NAME
, HOU.BUSINESS_GROUP_ID
, HOU.LOCATION_ID
, HOU.DATE_FROM
, HOU.DATE_TO
, HOU.COMMENTS
, HOU.ATTRIBUTE_CATEGORY
, HOU.ATTRIBUTE1
, HOU.ATTRIBUTE2
, HOU.ATTRIBUTE3
, HOU.ATTRIBUTE4
, HOU.ATTRIBUTE5
, HOU.ATTRIBUTE6
, HOU.ATTRIBUTE7
, HOU.ATTRIBUTE8
, HOU.ATTRIBUTE9
, HOU.ATTRIBUTE10
, HOU.ATTRIBUTE11
, HOU.ATTRIBUTE12
, HOU.ATTRIBUTE13
, HOU.ATTRIBUTE14
, HOU.ATTRIBUTE15
FROM HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS P
WHERE HOU.ORGANIZATION_ID = P.ORGANIZATION_ID