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 1943: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

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

Line 2043: FROM csp_planning_parameters

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

Line 2341: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

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

Line 2355: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

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

Line 2435: FROM csp_planning_parameters

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