APPS.CSP_ITEM_PL_PARAMS_PVT dependencies on CSP_PLANNING_PARAMETERS

Line 59: FROM csp_planning_parameters cpp

55: l_excess_edq_factor,
56: l_repair_edq_Factor,
57: l_newbuy_edq_Factor,
58: l_edq_multiple
59: FROM csp_planning_parameters cpp
60: WHERE organization_id = p_organization_id
61: and cpp.organization_type = 'W';
62:
63:

Line 165: FROM csp_planning_parameters cpp

161: decode(p_newbuy_edq_factor, cpp.newbuy_edq_factor, null, p_newbuy_edq_Factor) newbuy_edq_Factor,
162: decode(p_excess_edq_multiple, cpp.edq_multiple, null, p_excess_edq_multiple) excess_Edq_multiple,
163: decode(p_repair_edq_multiple, cpp.edq_multiple, null, p_repair_edq_multiple) repair_edq_multiple,
164: decode(p_newbuy_edq_multiple, cpp.edq_multiple, null, p_newbuy_edq_multiple) newbuy_edq_multiple
165: FROM csp_planning_parameters cpp
166: WHERE cpp.organization_id = p_organization_id
167: AND cpp.organization_type = 'W';
168:
169: csp_plan_details_pkg.reorders(p_organization_id,p_inventory_item_id);

Line 177: USING CSP_PLANNING_PARAMETERS cpp

173: END;
174:
175:
176: /* MERGE INTO CSP_ITEM_PL_PARAMS cipp
177: USING CSP_PLANNING_PARAMETERS cpp
178: ON (cipp.organization_id = p_organization_id
179: AND cipp.inventory_item_id = p_inventory_item_id)
180: WHEN MATCHED THEN
181: UPDATE SET cipp.excess_service_level = decode(p_excess_service_level, cpp.excess_service_level, FND_API.G_MISS_NUM, p_excess_service_level),