APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_PLAN_LEADTIMES

Line 93: csp_plan_leadtimes cpl,

89: nvl(cpl.repair_lead_time,0) repair_lead_time,
90: nvl(cpl.excess_lead_time,0) excess_lead_time,
91: nvl(cic.item_cost,0) item_cost
92: from csp_plan_details cpd,
93: csp_plan_leadtimes cpl,
94: cst_item_costs cic,
95: mtl_parameters mp,
96: csp_usage_headers cuh
97: where cpd.organization_id = l_organization_id

Line 464: delete from csp_plan_leadtimes

460:
461: procedure leadtimes is
462: begin
463:
464: delete from csp_plan_leadtimes
465: where organization_id = l_organization_id
466: and inventory_item_id = nvl(l_inventory_item_id,inventory_item_id);
467:
468: insert into csp_plan_leadtimes(

Line 468: insert into csp_plan_leadtimes(

464: delete from csp_plan_leadtimes
465: where organization_id = l_organization_id
466: and inventory_item_id = nvl(l_inventory_item_id,inventory_item_id);
467:
468: insert into csp_plan_leadtimes(
469: inventory_item_id,
470: organization_id,
471: excess_lead_time,
472: repair_lead_time,

Line 685: csp_plan_leadtimes cpl,

681: floor(cpl.NewBuy_Lead_Time/cfrb.period_size)))/cfrb.period_size),4))/ cpl.newbuy_lead_time) * 7 NewBuy_AWR,
682: cpd.inventory_item_id,
683: cpd.organization_id
684: from csp_plan_details cpd,
685: csp_plan_leadtimes cpl,
686: csp_planning_parameters cpp,
687: csp_forecast_rules_b cfrb
688: where cpd.organization_id = p_organization_id
689: and cpd.inventory_item_id = nvl(p_inventory_item_id, cpd.inventory_item_id)

Line 849: csp_plan_leadtimes cpl,

845: alpha,
846: beta,
847: nvl(cpl.repair_lead_time,0) repair_lead_time
848: from csp_plan_details cpd,
849: csp_plan_leadtimes cpl,
850: csp_forecast_rules_b cfrb
851: where cpd.organization_id = l_organization_id
852: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
853: and cpd.plan_detail_type = '6000'

Line 891: csp_plan_leadtimes cpl,

887: fnd_global.user_id,
888: sysdate,
889: fnd_global.login_id
890: from csp_plan_details cpd,
891: csp_plan_leadtimes cpl,
892: (select round(sum(cpd2.quantity* l_period_size /cfrb.period_size/cfrb.history_periods)) quantity,
893: cpd2.organization_id organization_id,
894: cpd2.inventory_item_id inventory_item_id
895: from csp_plan_details cpd2,

Line 940: csp_plan_leadtimes cpl,

936: fnd_global.user_id,
937: sysdate,
938: fnd_global.login_id
939: from csp_plan_details cpd,
940: csp_plan_leadtimes cpl,
941: (select round(sum(quantity*decode(round((trunc(sysdate)-trunc(plan_date))/l_forecast_period_size),
942: 1,weighted_avg_period1,
943: 2,weighted_avg_period2,
944: 3,weighted_avg_period3,

Line 3373: csp_plan_leadtimes cpl,

3369: fnd_global.login_id
3370: from csp_plan_details cpd,
3371: csp_planning_parameters cpp,
3372: csp_plan_reorders cpr,
3373: csp_plan_leadtimes cpl,
3374: csp_item_pl_params cipp
3375: where cpd.plan_detail_type = '1'
3376: and cpd.organization_id = p_organization_id
3377: and cpd.inventory_item_id = nvl(p_inventory_item_id,cpd.inventory_item_id)