[Home] [Help]
71: cwrv.nb_ext_ts_min,
72: cwrv.nb_ext_ts_max,
73: cwrv.nb_ext_lead_time
74: from csp_wrp_rules_vl cwrv,
75: csp_planning_parameters cpp
76: where cpp.organization_id = l_organization_id
77: and cpp.organization_type = 'W'
78: and cwrv.wrp_rule_id = cpp.wrp_rule_id;
79:
108: and nvl(cic.item_cost,0) > 0;
109:
110: cursor c_rep_int_ext(p_organization_id number,p_supplied_item_id number) is
111: select decode(misl.source_type,1,'INTERNAL','EXTERNAL')
112: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
113: where cpp.organization_id = p_organization_id
114: and misl.organization_id = cpp.organization_id
115: and misl.assignment_set_id =cpp.repair_assignment_set_id
116: and inventory_item_id = p_supplied_item_id
479: select
480: cpd.inventory_item_id,
481: cpd.organization_id,
482: (select max(nvl(mism1.intransit_time, 0))
483: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp, mtl_interorg_ship_methods mism1
484: where mism1.to_organization_id = cpp.organization_id
485: and mism1.from_organization_id = misl.source_organization_id
486: and mism1.default_flag = 1
487: and cpp.organization_id = cpd.organization_id
498: (select max(nvl(mism.intransit_time, 0) +
499: nvl(msib.repair_leadtime, 0) +
500: (select nvl(max(nvl(mism2.intransit_time, 0)), 0)
501: from MRP_ITEM_SOURCING_LEVELS_V misl1,
502: csp_planning_parameters cpp,
503: mtl_interorg_ship_methods mism2
504: where mism2.to_organization_id = decode(misl.source_type, 1, misl.source_organization_id, 3, hoi.organization_id)
505: and mism2.from_organization_id = misl1.source_organization_id
506: and mism2.default_flag = 1
516: and inventory_item_id = cpd.inventory_item_id
517: and sourcing_level not in (2,9))
518: ))
519: from MRP_ITEM_SOURCING_LEVELS_V misl,
520: csp_planning_parameters cpp,
521: mtl_interorg_ship_methods mism,
522: mtl_system_items_b msib,
523: hr_organization_information hoi
524: where msib.inventory_item_id = cpd.inventory_item_id
627: ,nvl(cuh.standard_deviation, 0) standard_deviation
628: from csp_usage_headers cuh,
629: cst_item_costs cic,
630: mtl_parameters mp,
631: csp_planning_parameters cpp1,
632: csp_item_pl_params cipp,
633: (select decode(nvl(cpl.Excess_Lead_Time, 0), 0, 0, round(sum(decode((cfrb.period_size *
634: floor(cpl.Excess_Lead_Time/cfrb.period_size)), 0, 0, decode(floor((cpd.plan_date - trunc(sysdate))/(cfrb.period_size *
635: floor(cpl.Excess_Lead_Time/cfrb.period_size))), 0, cpd.quantity, 0))) +
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)
690: and cpd.plan_detail_type = 1000
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.login_id
749: from csp_plan_details cpd,
750: csp_planning_parameters cpp,
751: csp_forecast_rules_b cfrb,
752: mtl_material_transactions mmt,
753: csp_usg_transaction_types cutt
754: where cpd.plan_detail_type in ('9002','9003')
800: max(a.period_size)
801: from csp_plan_details cpd,
802: (select round(max(cfrb.history_periods*cfrb.period_size)/max(cfrb.period_size)+0.499999) history_periods,max(cfrb.period_size) period_size,cpd.organization_id,cpd.inventory_item_id
803: from csp_forecast_rules_b cfrb,
804: csp_planning_parameters cpp,
805: csp_plan_details cpd
806: where cfrb.forecast_rule_id = cpp.forecast_rule_id
807: and cpd.plan_detail_type in ('6100','6200')
808: and cpd.source_organization_id = cpp.organization_id
893: cpd2.organization_id organization_id,
894: cpd2.inventory_item_id inventory_item_id
895: from csp_plan_details cpd2,
896: csp_forecast_rules_b cfrb,
897: csp_planning_parameters cpp
898: where cpd2.plan_detail_type = '6000'
899: and cpp.organization_id = cpd2.source_organization_id
900: and cfrb.forecast_rule_id = cpp.forecast_rule_id
901: and cfrb.forecast_method in (1,3,4)
954: cpd2.organization_id organization_id,
955: cpd2.inventory_item_id inventory_item_id
956: from csp_plan_details cpd2,
957: csp_forecast_rules_b cfrb,
958: csp_planning_parameters cpp
959: where cpd2.plan_detail_type = '6000'
960: and cpp.organization_id = cpd2.source_organization_id
961: and cfrb.forecast_rule_id = cpp.forecast_rule_id
962: and cfrb.forecast_method = 2
1266: sysdate,
1267: fnd_global.login_id
1268: from csp_failure_rates cfr,
1269: csp_population_changes cpc,
1270: csp_planning_parameters cpp
1271: where cfr.inventory_item_id = nvl(l_inventory_item_id,cfr.inventory_item_id)
1272: and cfr.product_id = cpc.product_id
1273: and cpc.organization_id = l_organization_id
1274: and cpp.organization_id = cpc.organization_id
3367: fnd_global.user_id,
3368: sysdate,
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'
3456: cursor c_forecast_rules is
3457: select cfrb.forecast_periods,
3458: cfrb.period_size
3459: from csp_forecast_rules_b cfrb,
3460: csp_planning_parameters cpp
3461: where cfrb.forecast_rule_id = cpp.forecast_rule_id
3462: and cpp.organization_id = p_organization_id
3463: and cpp.organization_type = 'W';
3464:
3510: cpp.level_id,
3511: cpp.reschedule_rule_id,
3512: cpp.minimum_value
3513: from csp_forecast_rules_b cfrb,
3514: csp_planning_parameters cpp
3515: where cfrb.forecast_rule_id = cpp.forecast_rule_id
3516: and cpp.organization_id = nvl(l_organization_id,cpp.organization_id)
3517: and cpp.organization_type = 'W';
3518: