[Home] [Help]
177: CURSOR PLANNING_NODE_REC IS
178: SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY,cpp.CONDITION_TYPE,
179: cpp.planning_parameters_id,cpp.level_id,csin.parts_loop_id,csin.hierarchy_node_id,
180: csin.owner_resource_id, csin.owner_resource_type
181: FROM CSP_PLANNING_PARAMETERS cpp,csp_sec_inventories csin
182: WHERE LEVEL_ID LIKE p_level_id||'%'
183: and cpp.organization_id = csin.organization_id(+)
184: and cpp.secondary_inventory = csin.secondary_inventory_name(+);
185:
213:
214: cursor c_org_subinventories(c_inventory_item_id number) is
215: select distinct moq.subinventory_code
216: from mtl_onhand_quantities moq,
217: csp_planning_parameters cpp
218: where moq.organization_id = p_organization_id
219: and moq.inventory_item_id = c_inventory_item_id
220: and cpp.organization_id = moq.organization_id
221: and cpp.secondary_inventory = moq.subinventory_code
223:
224: cursor c_subinventories is
225: select msi.secondary_inventory_name
226: from mtl_secondary_inventories msi,
227: csp_planning_parameters cpp
228: where msi.organization_id = p_organization_id
229: and msi.secondary_inventory_name = nvl(p_subinventory_code,msi.secondary_inventory_name)
230: and cpp.organization_id = msi.organization_id
231: and cpp.secondary_inventory = msi.secondary_inventory_name
1458: l_excess_rule_id number;
1459:
1460: cursor subinventory_br is
1461: select cpp.excess_rule_id
1462: from csp_planning_parameters cpp
1463: where cpp.organization_id = p_organization_id
1464: and cpp.secondary_inventory = p_subinventory_code;
1465:
1466: cursor organization_br is
1464: and cpp.secondary_inventory = p_subinventory_code;
1465:
1466: cursor organization_br is
1467: select cpp.excess_rule_id
1468: from csp_planning_parameters cpp
1469: where cpp.organization_id = p_organization_id
1470: and cpp.secondary_inventory is null;
1471:
1472: begin
2379:
2380: cursor c_Source_Org_Type (v_org_id number, v_subinv varchar2) is
2381: select
2382: nvl(stocking_site_type, 'MANNED')
2383: from csp_planning_parameters
2384: where organization_id = v_org_id
2385: and nvl(secondary_inventory, 'NULL') = nvl(v_subinv, 'NULL');
2386:
2387: l_Source_Org_Type varchar2(20);
2430: h.province,
2431: h.county,
2432: h.country
2433: from
2434: csp_planning_parameters c,
2435: hz_locations h
2436: where c.organization_id = v_org_id
2437: and nvl(c.secondary_inventory, 'NULL') = nvl(v_subinv, 'NULL')
2438: and c.hz_location_id = h.location_id;
2744: hoa.location_id,
2745: ood.operating_unit
2746: from csp_return_routing_rules crrr,
2747: hr_organization_units hoa,
2748: csp_planning_parameters cpp,
2749: org_organization_definitions ood
2750: where crrr.rule_id = p_return_rule_id
2751: and crrr.dest_subinv is null
2752: and crrr.dest_org_id = hoa.organization_id
2760: msi.location_id,
2761: ood.operating_unit
2762: from csp_return_routing_rules crrr,
2763: mtl_secondary_inventories msi,
2764: csp_planning_parameters cpp,
2765: org_organization_definitions ood
2766: where crrr.rule_id = p_return_rule_id
2767: and crrr.dest_org_id = msi.organization_id
2768: and crrr.dest_subinv = msi.secondary_inventory_name