[Home] [Help]
View: CSP_REGION_ITEMS_V
View Text
SELECT CUR.PLANNING_PARAMETERS_ID
, CUR.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, CPP.SECONDARY_INVENTORY
, CUR.LEVEL_ID
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_USAGE_REG_MV CUR
WHERE CPP.NODE_TYPE IN ('ORGANIZATON_WH'
, 'SUBINVENTORY')
AND CUR.PLANNING_PARAMETERS_ID = CPP.PARENT_NODE_ID GROUP BY CUR.PLANNING_PARAMETERS_ID
, CUR.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, CPP.SECONDARY_INVENTORY
, CUR.LEVEL_ID
Columns
Name |
PLANNING_PARAMETERS_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SECONDARY_INVENTORY |
LEVEL_ID |