[Home] [Help]
View: RHX_DP_R_CATEGORY_ITEMORG_V
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CAT.CATEGORY_ID
, CAT.CONCATENATED_SEGMENTS
, ITEMORG.ITEM_ORG
, ITEMORG.INVENTORY_ITEM_ID
, ITEMORG.ORGANIZATION_ID
FROM MTL_CATEGORIES_KFV CAT
, MTL_CATEGORY_SETS MCS
, MTL_ITEM_CATEGORIES MIC
, RHX_DP_L_ITEMORG_V ITEMORG
WHERE MIC.INVENTORY_ITEM_ID = ITEMORG.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = ITEMORG.ORGANIZATION_ID
AND MIC.CATEGORY_SET_ID = RHX_DP.GET_PARAMETER('RHX_DP_P_CATEGORY_SET')
AND MCS .CATEGORY_SET_ID = MIC.CATEGORY_SET_ID
AND CAT.STRUCTURE_ID = MCS.STRUCTURE_ID
AND CAT.CATEGORY_ID = MIC.CATEGORY_ID
Columns
Name |
CATEGORY_ID |
CATEGORY |
ITEM_ORG |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |