80: l_done varchar2(1);
81:
82: CURSOR PLANNING_NODE_REC IS
83: SELECT NODE_TYPE,ORGANIZATION_ID,SECONDARY_INVENTORY
84: FROM CSP_PLANNING_PARAMETERS
85: WHERE LEVEL_ID LIKE p_level_id||'%'
86: and node_type = 'ORGANIZATION_WH'
87: union all
88: SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY
85: WHERE LEVEL_ID LIKE p_level_id||'%'
86: and node_type = 'ORGANIZATION_WH'
87: union all
88: SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY
89: FROM CSP_PLANNING_PARAMETERS cpp,
90: mtl_secondary_inventories msi
91: WHERE LEVEL_ID LIKE p_level_id||'%'
92: and node_type = 'SUBINVENTORY'
93: and msi.organization_id = cpp.organization_id