[Home] [Help]
View: RHX_DP_R_ITEM_ITEMORG_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ITEM.CONCATENATED_SEGMENTS
, ITEMORG.ITEM_ORG
, ITEMORG.INVENTORY_ITEM_ID
, ITEMORG.ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_KFV ITEM
, RHX_DP_L_ITEMORG_V ITEMORG
WHERE ITEM.INVENTORY_ITEM_ID = ITEMORG.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = ITEMORG.ORGANIZATION_ID
Columns
Name |
ITEM |
ITEM_ORG |
ITEM_ORG_ITEM_ID |
ITEM_ORG_ORGANIZATION_ID |