[Home] [Help]
175: CURSOR PLANNING_NODE_REC IS
176: SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY,cpp.CONDITION_TYPE,
177: cpp.planning_parameters_id,cpp.level_id,csin.parts_loop_id,csin.hierarchy_node_id,
178: csin.owner_resource_id, csin.owner_resource_type
179: FROM CSP_PLANNING_PARAMETERS cpp,csp_sec_inventories csin
180: WHERE LEVEL_ID LIKE p_level_id||'%'
181: and cpp.organization_id = csin.organization_id(+)
182: and cpp.secondary_inventory = csin.secondary_inventory_name(+);
183:
211:
212: cursor c_org_subinventories(c_inventory_item_id number) is
213: select distinct moq.subinventory_code
214: from mtl_onhand_quantities moq,
215: csp_planning_parameters cpp
216: where moq.organization_id = p_organization_id
217: and moq.inventory_item_id = c_inventory_item_id
218: and cpp.organization_id = moq.organization_id
219: and cpp.secondary_inventory = moq.subinventory_code
221:
222: cursor c_subinventories is
223: select msi.secondary_inventory_name
224: from mtl_secondary_inventories msi,
225: csp_planning_parameters cpp
226: where msi.organization_id = p_organization_id
227: and msi.secondary_inventory_name = nvl(p_subinventory_code,msi.secondary_inventory_name)
228: and cpp.organization_id = msi.organization_id
229: and cpp.secondary_inventory = msi.secondary_inventory_name
1337: l_excess_rule_id number;
1338:
1339: cursor subinventory_br is
1340: select cpp.excess_rule_id
1341: from csp_planning_parameters cpp
1342: where cpp.organization_id = p_organization_id
1343: and cpp.secondary_inventory = p_subinventory_code;
1344:
1345: cursor organization_br is
1343: and cpp.secondary_inventory = p_subinventory_code;
1344:
1345: cursor organization_br is
1346: select cpp.excess_rule_id
1347: from csp_planning_parameters cpp
1348: where cpp.organization_id = p_organization_id
1349: and cpp.secondary_inventory is null;
1350:
1351: begin