APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_PLANNING_PARAMETERS

Line 888: from csp_planning_parameters

884: select edq_multiple,
885: minimum_Value
886: into l_Edq_multiple,
887: l_min_Value
888: from csp_planning_parameters
889: where organization_id = p_organization_id
890: and secondary_inventory is null;
891:
892: l_edq := mrc.MAX_QTY - mrc.MIN_QTY;

Line 1170: FROM csp_planning_parameters

1166: IF (p_restock = 1) THEN
1167: begin
1168: SELECT notification_rule_id
1169: INTO l_business_rule_id
1170: FROM csp_planning_parameters
1171: WHERE organization_id = p_organization_id
1172: AND node_type = 'ORGANIZATION_WH';
1173:
1174: IF l_business_rule_id IS NOT NULL THEN

Line 1940: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

1936: l_atr NUMBER;
1937:
1938: CURSOR excess_sources_cur IS
1939: select misl.source_organization_id
1940: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
1941: where cpp.organization_id = p_organization_id
1942: and misl.organization_id = cpp.organization_id
1943: and misl.assignment_set_id =cpp.usable_assignment_set_id
1944: and inventory_item_id = p_item_rec.inventory_item_id

Line 2040: FROM csp_planning_parameters

2036: SELECT organization_type,
2037: condition_type
2038: INTO l_organization_type,
2039: l_condition_type
2040: FROM csp_planning_parameters
2041: WHERE organization_id = esc.source_organization_id
2042: AND secondary_inventory IS NULL;
2043: EXCEPTION
2044: WHEN NO_DATA_FOUND THEN

Line 2338: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

2334: ) IS
2335:
2336: CURSOR repair_sources_cur IS
2337: select misl.source_organization_id
2338: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
2339: where cpp.organization_id = p_organization_id
2340: and misl.organization_id = cpp.organization_id
2341: and misl.assignment_set_id =cpp.defective_assignment_set_id
2342: and inventory_item_id = p_inventory_item_id

Line 2352: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

2348: and sourcing_level not in (2,9));
2349:
2350: CURSOR repair_suppliers_cur IS
2351: select misl.source_type, misl.source_organization_id
2352: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
2353: where cpp.organization_id = p_organization_id
2354: and misl.organization_id = cpp.organization_id
2355: and misl.assignment_set_id =cpp.repair_assignment_set_id
2356: and inventory_item_id = p_inventory_item_id

Line 2432: FROM csp_planning_parameters

2428: SELECT organization_type,
2429: nvl(condition_type, 'G')
2430: INTO l_organization_type,
2431: l_condition_type
2432: FROM csp_planning_parameters
2433: WHERE organization_id = rep.source_organization_id
2434: AND secondary_inventory IS NULL;
2435: EXCEPTION
2436: WHEN NO_DATA_FOUND THEN