[Home] [Help]
View: RHX_DP_R_ORG_ITEMORG_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ORG.ORGANIZATION_CODE
, ITEMORG.ITEM_ORG
, ITEMORG.INVENTORY_ITEM_ID
, ITEMORG.ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, MTL_SYSTEM_ITEMS_KFV MSI
, RHX_DP_L_ITEMORG_V ITEMORG
WHERE MSI.INVENTORY_ITEM_ID = ITEMORG.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = ITEMORG.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = ORG.ORGANIZATION_ID
Columns
Name |
ORG |
ITEM_ORG |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |