[Home] [Help]
548: nvl(msib.postprocessing_lead_time,0))
549: from mtl_system_items_b msib
550: where inventory_item_id = cpd.inventory_item_id
551: and organization_id = cpd.organization_id) NewBuy_Lead_Time,
552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.login_id
550: where inventory_item_id = cpd.inventory_item_id
551: and organization_id = cpd.organization_id) NewBuy_Lead_Time,
552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.login_id
557: from csp_plan_Details cpd
558: where plan_detail_type = '1'
552: fnd_global.user_id,
553: sysdate,
554: fnd_global.user_id,
555: sysdate,
556: fnd_global.login_id
557: from csp_plan_Details cpd
558: where plan_detail_type = '1'
559: and organization_id = l_organization_id
560: and inventory_item_id = nvl(l_inventory_item_id, inventory_item_id)
598: b.newbuy_edq,
599: (nvl(csf.safety_factor,0) * nvl(b.standard_deviation, 0)) excess_safety_stock,
600: (nvl(csf1.safety_factor,0) * nvl(b.standard_deviation, 0)) repair_safety_stock,
601: (nvl(csf2.safety_factor,0) * nvl(b.standard_deviation, 0)) newbuy_safety_stock,
602: fnd_global.user_id,
603: sysdate,
604: fnd_global.user_id,
605: sysdate,
606: fnd_global.login_id
600: (nvl(csf1.safety_factor,0) * nvl(b.standard_deviation, 0)) repair_safety_stock,
601: (nvl(csf2.safety_factor,0) * nvl(b.standard_deviation, 0)) newbuy_safety_stock,
602: fnd_global.user_id,
603: sysdate,
604: fnd_global.user_id,
605: sysdate,
606: fnd_global.login_id
607: from csp_safety_factors csf,
608: csp_Safety_factors csf1,
602: fnd_global.user_id,
603: sysdate,
604: fnd_global.user_id,
605: sysdate,
606: fnd_global.login_id
607: from csp_safety_factors csf,
608: csp_Safety_factors csf1,
609: csp_safety_factors csf2,
610: (select decode(nvl(cpp1.safety_stock_flag, 'N'), 'N', 0, decode(a.excess_awr, 0, 0 , decode(nvl(cuh.item_cost, 0), 0, 0, decode(nvl(cipp.excess_edq_factor, cpp1.excess_edq_factor), 0, 0,
740: cpd.organization_id,
741: cpd.source_organization_id,
742: sum(mmt.primary_quantity),
743: trunc(trunc(sysdate) - round((trunc(sysdate) - trunc(mmt.transaction_date))/cfrb.period_size)*cfrb.period_size),
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.login_id
742: sum(mmt.primary_quantity),
743: trunc(trunc(sysdate) - round((trunc(sysdate) - trunc(mmt.transaction_date))/cfrb.period_size)*cfrb.period_size),
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.login_id
749: from csp_plan_details cpd,
750: csp_planning_parameters cpp,
744: fnd_global.user_id,
745: sysdate,
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,
790: sum(quantity),
791: cpd.plan_date,
792: cpd.inventory_item_id,
793: cpd.organization_id,
794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate,
798: fnd_global.login_id,
792: cpd.inventory_item_id,
793: cpd.organization_id,
794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate,
798: fnd_global.login_id,
799: max(a.history_periods),
800: max(a.period_size)
794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate,
798: fnd_global.login_id,
799: max(a.history_periods),
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
881: a.quantity,
882: trunc(sysdate + cpl.repair_lead_time + (rownum-1) * l_period_size),
883: cpd.inventory_item_id,
884: cpd.organization_id,
885: fnd_global.user_id,
886: sysdate,
887: fnd_global.user_id,
888: sysdate,
889: fnd_global.login_id
883: cpd.inventory_item_id,
884: cpd.organization_id,
885: fnd_global.user_id,
886: sysdate,
887: fnd_global.user_id,
888: sysdate,
889: fnd_global.login_id
890: from csp_plan_details cpd,
891: csp_plan_leadtimes cpl,
885: fnd_global.user_id,
886: sysdate,
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,
930: a.quantity,
931: trunc(sysdate + cpl.repair_lead_time + (rownum-1) * l_period_size),
932: cpd.inventory_item_id,
933: cpd.organization_id,
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.login_id
932: cpd.inventory_item_id,
933: cpd.organization_id,
934: fnd_global.user_id,
935: sysdate,
936: fnd_global.user_id,
937: sysdate,
938: fnd_global.login_id
939: from csp_plan_details cpd,
940: csp_plan_leadtimes cpl,
934: fnd_global.user_id,
935: sysdate,
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,
994: l_forecast * l_period_size/l_forecast_period_size,
995: trunc(sysdate + cr.repair_lead_time + (rownum-1) * l_period_size),
996: l_item,
997: l_organization_id,
998: fnd_global.user_id,
999: sysdate,
1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id
996: l_item,
997: l_organization_id,
998: fnd_global.user_id,
999: sysdate,
1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id
1003: from csp_plan_details
1004: where organization_id = l_organization_id
998: fnd_global.user_id,
999: sysdate,
1000: fnd_global.user_id,
1001: sysdate,
1002: fnd_global.login_id
1003: from csp_plan_details
1004: where organization_id = l_organization_id
1005: and rownum <= l_forecast_periods;
1006: l_start := 1;
1040: l_forecast * l_period_size/l_forecast_period_size,
1041: trunc(sysdate + l_repair_lead_time + (rownum -1) * l_period_size),
1042: l_item,
1043: l_organization_id,
1044: fnd_global.user_id,
1045: sysdate,
1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.login_id
1042: l_item,
1043: l_organization_id,
1044: fnd_global.user_id,
1045: sysdate,
1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.login_id
1049: from csp_plan_details
1050: where organization_id = l_organization_id
1044: fnd_global.user_id,
1045: sysdate,
1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.login_id
1049: from csp_plan_details
1050: where organization_id = l_organization_id
1051: and rownum <= l_forecast_periods;
1052: elsif l_forecast_method = -4 then
1073: l_forecast + l_trend * rownum * l_period_size/l_forecast_period_size,
1074: trunc(sysdate + cr.repair_lead_time + (rownum-1) * l_period_size),
1075: l_item,
1076: l_organization_id,
1077: fnd_global.user_id,
1078: sysdate,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id
1075: l_item,
1076: l_organization_id,
1077: fnd_global.user_id,
1078: sysdate,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id
1082: from csp_plan_details
1083: where organization_id = l_organization_id
1077: fnd_global.user_id,
1078: sysdate,
1079: fnd_global.user_id,
1080: sysdate,
1081: fnd_global.login_id
1082: from csp_plan_details
1083: where organization_id = l_organization_id
1084: and rownum <= l_forecast_periods;
1085: l_start := 1;
1129: l_forecast + l_trend * rownum * l_period_size/l_forecast_period_size,
1130: trunc(sysdate + l_repair_lead_time + (rownum-1) * l_period_size),
1131: l_item,
1132: l_organization_id,
1133: fnd_global.user_id,
1134: sysdate,
1135: fnd_global.user_id,
1136: sysdate,
1137: fnd_global.login_id
1131: l_item,
1132: l_organization_id,
1133: fnd_global.user_id,
1134: sysdate,
1135: fnd_global.user_id,
1136: sysdate,
1137: fnd_global.login_id
1138: from csp_plan_details
1139: where organization_id = l_organization_id
1133: fnd_global.user_id,
1134: sysdate,
1135: fnd_global.user_id,
1136: sysdate,
1137: fnd_global.login_id
1138: from csp_plan_details
1139: where organization_id = l_organization_id
1140: and rownum <= l_forecast_periods;
1141:
1168: round(sum(quantity*l_period_size/cfrb.period_size)),
1169: trunc(sysdate) + (l_counter - 1) * l_period_size,
1170: inventory_item_id,
1171: organization_id,
1172: fnd_global.user_id,
1173: sysdate,
1174: fnd_global.user_id,
1175: sysdate,
1176: fnd_global.login_id
1170: inventory_item_id,
1171: organization_id,
1172: fnd_global.user_id,
1173: sysdate,
1174: fnd_global.user_id,
1175: sysdate,
1176: fnd_global.login_id
1177: from csp_usage_histories cuh,
1178: csp_forecast_rules_b cfrb
1172: fnd_global.user_id,
1173: sysdate,
1174: fnd_global.user_id,
1175: sysdate,
1176: fnd_global.login_id
1177: from csp_usage_histories cuh,
1178: csp_forecast_rules_b cfrb
1179: where history_data_type = 2
1180: and period_start_date between decode(l_forecast_method,4,trunc(sysdate) + (l_counter - 1) * l_period_size,period_start_date)
1188: trunc(sysdate) + (l_counter - 1) * l_period_size,
1189: inventory_item_id,
1190: organization_id,
1191: sysdate,
1192: fnd_global.user_id,
1193: sysdate,
1194: fnd_global.login_id;
1195: -- Manual Forecast
1196: insert into csp_plan_details(
1190: organization_id,
1191: sysdate,
1192: fnd_global.user_id,
1193: sysdate,
1194: fnd_global.login_id;
1195: -- Manual Forecast
1196: insert into csp_plan_details(
1197: plan_detail_type,
1198: parent_type,
1214: sum(quantity),
1215: trunc(sysdate) + (l_counter - 1) * l_period_size,
1216: inventory_item_id,
1217: organization_id,
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.login_id
1216: inventory_item_id,
1217: organization_id,
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.login_id
1223: from csp_usage_histories cuh
1224: where history_data_type in (7,8)
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.login_id
1223: from csp_usage_histories cuh
1224: where history_data_type in (7,8)
1225: and period_start_date between trunc(sysdate) + (l_counter - 1) * l_period_size
1226: and trunc(sysdate) + l_counter * l_period_size - 1
1231: trunc(sysdate) + (l_counter - 1) * l_period_size,
1232: inventory_item_id,
1233: organization_id,
1234: sysdate,
1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.login_id;
1238:
1239: -- Population Forecast
1233: organization_id,
1234: sysdate,
1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.login_id;
1238:
1239: -- Population Forecast
1240: insert into csp_plan_details(
1241: plan_detail_type,
1259: (least(cpc.end_date,(trunc(sysdate)+(l_counter)*l_period_size)) - trunc(sysdate))/(cpc.end_date - cpc.start_date))),
1260: trunc(sysdate) + (l_counter-1) * l_period_size,
1261: cfr.inventory_item_id,
1262: cpc.organization_id,
1263: fnd_global.user_id,
1264: sysdate,
1265: fnd_global.user_id,
1266: sysdate,
1267: fnd_global.login_id
1261: cfr.inventory_item_id,
1262: cpc.organization_id,
1263: fnd_global.user_id,
1264: sysdate,
1265: fnd_global.user_id,
1266: sysdate,
1267: fnd_global.login_id
1268: from csp_failure_rates cfr,
1269: csp_population_changes cpc,
1263: fnd_global.user_id,
1264: sysdate,
1265: fnd_global.user_id,
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)
1304: greatest(sum(cpd.quantity),0),
1305: max(trunc(trunc(sysdate) + ((cpd.plan_date - trunc(sysdate))/l_period_size)*l_period_size)),
1306: cpd.inventory_item_id,
1307: cpd.source_organization_id,
1308: max(fnd_global.user_id),
1309: max(sysdate),
1310: max(fnd_global.user_id),
1311: max(sysdate),
1312: max(fnd_global.login_id)
1306: cpd.inventory_item_id,
1307: cpd.source_organization_id,
1308: max(fnd_global.user_id),
1309: max(sysdate),
1310: max(fnd_global.user_id),
1311: max(sysdate),
1312: max(fnd_global.login_id)
1313: from csp_plan_details cpd
1314: where cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1308: max(fnd_global.user_id),
1309: max(sysdate),
1310: max(fnd_global.user_id),
1311: max(sysdate),
1312: max(fnd_global.login_id)
1313: from csp_plan_details cpd
1314: where cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1315: and cpd.source_organization_id = l_organization_id
1316: and cpd.plan_detail_type = '4310'
1337: greatest(sum(cpd.quantity),0),
1338: cpd.plan_date,
1339: cpd.inventory_item_id,
1340: cpd.organization_id,
1341: max(fnd_global.user_id),
1342: max(sysdate),
1343: max(fnd_global.user_id),
1344: max(sysdate),
1345: max(fnd_global.login_id)
1339: cpd.inventory_item_id,
1340: cpd.organization_id,
1341: max(fnd_global.user_id),
1342: max(sysdate),
1343: max(fnd_global.user_id),
1344: max(sysdate),
1345: max(fnd_global.login_id)
1346: from csp_plan_details cpd
1347: where cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1341: max(fnd_global.user_id),
1342: max(sysdate),
1343: max(fnd_global.user_id),
1344: max(sysdate),
1345: max(fnd_global.login_id)
1346: from csp_plan_details cpd
1347: where cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1348: and cpd.organization_id = l_organization_id
1349: and cpd.plan_detail_type = '1610'
1382: 0,trunc(sysdate),
1383: 1,trunc(sysdate) + trunc((trunc(nvl(oola.schedule_ship_date,nvl(oola.promise_date,oola.request_date)))-trunc(sysdate))/l_period_size)*l_period_size),
1384: oola.inventory_item_id,
1385: oola.ship_from_org_id,
1386: fnd_global.user_id,
1387: sysdate,
1388: fnd_global.user_id,
1389: sysdate,
1390: fnd_global.login_id
1384: oola.inventory_item_id,
1385: oola.ship_from_org_id,
1386: fnd_global.user_id,
1387: sysdate,
1388: fnd_global.user_id,
1389: sysdate,
1390: fnd_global.login_id
1391: from oe_order_lines_all oola
1392: where oola.ship_from_org_id = l_organization_id
1386: fnd_global.user_id,
1387: sysdate,
1388: fnd_global.user_id,
1389: sysdate,
1390: fnd_global.login_id
1391: from oe_order_lines_all oola
1392: where oola.ship_from_org_id = l_organization_id
1393: and oola.open_flag = 'Y'
1394: and nvl(oola.order_source_id,0) <> 10
1434: sum(to_org_primary_quantity),
1435: trunc(nvl(expected_delivery_date,nvl(crph.need_by_date,nvl(ms.need_by_date,trunc(sysdate))))),
1436: ms.item_id,
1437: ms.to_organization_id,
1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.login_id
1436: ms.item_id,
1437: ms.to_organization_id,
1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.login_id
1443: from mtl_supply ms,
1444: csp_repair_po_headers crph,
1438: fnd_global.user_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.login_id
1443: from mtl_supply ms,
1444: csp_repair_po_headers crph,
1445: po_headers_all pha,
1446: po_vendors pv,
1498: sum(ms.to_org_primary_quantity),
1499: trunc(nvl(ms.expected_delivery_date,nvl(crph.need_by_date,nvl(ms.need_by_date,trunc(sysdate))))),
1500: ms.item_id,
1501: ms.to_organization_id,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: sysdate,
1506: fnd_global.login_id
1500: ms.item_id,
1501: ms.to_organization_id,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: sysdate,
1506: fnd_global.login_id
1507: from mtl_supply ms,
1508: csp_repair_po_headers crph,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: sysdate,
1506: fnd_global.login_id
1507: from mtl_supply ms,
1508: csp_repair_po_headers crph,
1509: po_requisition_headers_all prha,
1510: oe_order_headers_all ooha,
1555: pria.quantity,
1556: trunc(nvl(pria.need_by_date,nvl(crph.need_by_date,trunc(sysdate)))),
1557: pria.item_id,
1558: pria.destination_organization_id,
1559: fnd_global.user_id,
1560: sysdate,
1561: fnd_global.user_id,
1562: sysdate,
1563: fnd_global.login_id
1557: pria.item_id,
1558: pria.destination_organization_id,
1559: fnd_global.user_id,
1560: sysdate,
1561: fnd_global.user_id,
1562: sysdate,
1563: fnd_global.login_id
1564: from po_requisitions_interface_all pria,
1565: csp_repair_po_headers crph
1559: fnd_global.user_id,
1560: sysdate,
1561: fnd_global.user_id,
1562: sysdate,
1563: fnd_global.login_id
1564: from po_requisitions_interface_all pria,
1565: csp_repair_po_headers crph
1566: where pria.destination_organization_id = l_organization_id
1567: and pria.item_id = nvl(l_inventory_item_id,pria.item_id)
1588: wjsi.start_quantity,
1589: trunc(nvl(wjsi.last_unit_completion_date,sysdate)),
1590: wjsi.primary_item_id,
1591: wjsi.organization_id,
1592: -1001012,--fnd_global.user_id,
1593: sysdate,
1594: fnd_global.user_id,
1595: sysdate,
1596: fnd_global.login_id
1590: wjsi.primary_item_id,
1591: wjsi.organization_id,
1592: -1001012,--fnd_global.user_id,
1593: sysdate,
1594: fnd_global.user_id,
1595: sysdate,
1596: fnd_global.login_id
1597: from wip_job_schedule_interface wjsi
1598: where wjsi.organization_id = l_organization_id
1592: -1001012,--fnd_global.user_id,
1593: sysdate,
1594: fnd_global.user_id,
1595: sysdate,
1596: fnd_global.login_id
1597: from wip_job_schedule_interface wjsi
1598: where wjsi.organization_id = l_organization_id
1599: and wjsi.primary_item_id = nvl(l_inventory_item_id,wjsi.primary_item_id);
1600: */
1791: 'NEWBUY',min(nvl(cpr.newbuy_safety_stock,0)))) * -1,
1792: min(trunc(sysdate+i*l_period_size)),
1793: cpd.inventory_item_id,
1794: cpd.organization_id,
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: sysdate,
1799: fnd_global.login_id
1793: cpd.inventory_item_id,
1794: cpd.organization_id,
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: sysdate,
1799: fnd_global.login_id
1800: from csp_plan_details cpd,
1801: csp_plan_reorders cpr
1795: fnd_global.user_id,
1796: sysdate,
1797: fnd_global.user_id,
1798: sysdate,
1799: fnd_global.login_id
1800: from csp_plan_details cpd,
1801: csp_plan_reorders cpr
1802: where cpd.plan_detail_type in ('1','1000','2000','4110','4210','4310','4220')
1803: and cpr.organization_id (+) = cpd.organization_id
1864: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0)*nvl(min(cipp.excess_edq_multiple),nvl(l_edq_multiple,1)),0))) excess_cancel_newbuy,
1865: min(cpd.plan_date),
1866: cpd.inventory_item_id,
1867: cpd.organization_id,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: sysdate,
1872: fnd_global.login_id
1866: cpd.inventory_item_id,
1867: cpd.organization_id,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: sysdate,
1872: fnd_global.login_id
1873: from csp_plan_details cpd,
1874: csp_plan_reorders cpr,
1868: fnd_global.user_id,
1869: sysdate,
1870: fnd_global.user_id,
1871: sysdate,
1872: fnd_global.login_id
1873: from csp_plan_details cpd,
1874: csp_plan_reorders cpr,
1875: csp_item_pl_params cipp
1876: where cpd.organization_id = l_organization_id
1888: cpr.excess_rop,
1889: cpr.excess_edq,
1890: cpd.inventory_item_id,
1891: cpd.organization_id,
1892: fnd_global.user_id,
1893: sysdate,
1894: fnd_global.user_id,
1895: sysdate,
1896: fnd_global.login_id;
1890: cpd.inventory_item_id,
1891: cpd.organization_id,
1892: fnd_global.user_id,
1893: sysdate,
1894: fnd_global.user_id,
1895: sysdate,
1896: fnd_global.login_id;
1897: -- Delete new buy excess on orders that have a value less than minimum value
1898: delete from csp_plan_details
1892: fnd_global.user_id,
1893: sysdate,
1894: fnd_global.user_id,
1895: sysdate,
1896: fnd_global.login_id;
1897: -- Delete new buy excess on orders that have a value less than minimum value
1898: delete from csp_plan_details
1899: where (plan_detail_type,organization_id,inventory_item_id) in
1900: (select cpd.plan_detail_type,cpd.organization_id,cpd.inventory_item_id
1935: sum(decode(cpd.plan_detail_type,'4110',nvl(cpd.quantity*-1,0),'9001',nvl(cpd.quantity,0),0))),0),
1936: min(cpd.plan_date),
1937: cpd.inventory_item_id,
1938: cpd.organization_id,
1939: fnd_global.user_id,
1940: sysdate,
1941: fnd_global.user_id,
1942: sysdate,
1943: fnd_global.login_id
1937: cpd.inventory_item_id,
1938: cpd.organization_id,
1939: fnd_global.user_id,
1940: sysdate,
1941: fnd_global.user_id,
1942: sysdate,
1943: fnd_global.login_id
1944: from csp_plan_details cpd,
1945: csp_plan_reorders cpr
1939: fnd_global.user_id,
1940: sysdate,
1941: fnd_global.user_id,
1942: sysdate,
1943: fnd_global.login_id
1944: from csp_plan_details cpd,
1945: csp_plan_reorders cpr
1946: where cpd.organization_id = l_organization_id
1947: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1956: cpr.excess_rop,
1957: cpr.excess_edq,
1958: cpd.inventory_item_id,
1959: cpd.organization_id,
1960: fnd_global.user_id,
1961: sysdate,
1962: fnd_global.user_id,
1963: sysdate,
1964: fnd_global.login_id;
1958: cpd.inventory_item_id,
1959: cpd.organization_id,
1960: fnd_global.user_id,
1961: sysdate,
1962: fnd_global.user_id,
1963: sysdate,
1964: fnd_global.login_id;
1965: /*
1966: insert into csp_plan_details(
1960: fnd_global.user_id,
1961: sysdate,
1962: fnd_global.user_id,
1963: sysdate,
1964: fnd_global.login_id;
1965: /*
1966: insert into csp_plan_details(
1967: plan_detail_type,
1968: parent_type,
1985: sum(decode(cpd.plan_detail_type,'2100',nvl(cpd.quantity*-1,0),'8210',nvl(cpd.quantity*-1,0),'9001',nvl(cpd.quantity,0),0))),0),
1986: min(cpd.plan_date),
1987: cpd.inventory_item_id,
1988: cpd.organization_id,
1989: -10014,--fnd_global.user_id,
1990: sysdate,
1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.login_id
1987: cpd.inventory_item_id,
1988: cpd.organization_id,
1989: -10014,--fnd_global.user_id,
1990: sysdate,
1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.login_id
1994: from csp_plan_details cpd,
1995: csp_plan_reorders cpr
1989: -10014,--fnd_global.user_id,
1990: sysdate,
1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.login_id
1994: from csp_plan_details cpd,
1995: csp_plan_reorders cpr
1996: where cpd.organization_id = l_organization_id
1997: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2006: cpr.excess_rop,
2007: cpr.excess_edq,
2008: cpd.inventory_item_id,
2009: cpd.organization_id,
2010: -10016,--fnd_global.user_id,
2011: sysdate,
2012: fnd_global.user_id,
2013: sysdate,
2014: fnd_global.login_id;
2008: cpd.inventory_item_id,
2009: cpd.organization_id,
2010: -10016,--fnd_global.user_id,
2011: sysdate,
2012: fnd_global.user_id,
2013: sysdate,
2014: fnd_global.login_id;
2015: */
2016: insert into csp_plan_details(
2010: -10016,--fnd_global.user_id,
2011: sysdate,
2012: fnd_global.user_id,
2013: sysdate,
2014: fnd_global.login_id;
2015: */
2016: insert into csp_plan_details(
2017: plan_detail_type,
2018: parent_type,
2035: sum(decode(cpd.plan_detail_type,'4100',nvl(cpd.quantity*-1,0),'8210',nvl(cpd.quantity*-1,0),'9001',nvl(cpd.quantity,0),0))),0),
2036: min(cpd.plan_date),
2037: cpd.inventory_item_id,
2038: cpd.organization_id,
2039: fnd_global.user_id,
2040: sysdate,
2041: fnd_global.user_id,
2042: sysdate,
2043: fnd_global.login_id
2037: cpd.inventory_item_id,
2038: cpd.organization_id,
2039: fnd_global.user_id,
2040: sysdate,
2041: fnd_global.user_id,
2042: sysdate,
2043: fnd_global.login_id
2044: from csp_plan_details cpd,
2045: csp_plan_reorders cpr
2039: fnd_global.user_id,
2040: sysdate,
2041: fnd_global.user_id,
2042: sysdate,
2043: fnd_global.login_id
2044: from csp_plan_details cpd,
2045: csp_plan_reorders cpr
2046: where cpd.organization_id = l_organization_id
2047: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2056: cpr.excess_rop,
2057: cpr.excess_edq,
2058: cpd.inventory_item_id,
2059: cpd.organization_id,
2060: fnd_global.user_id,
2061: sysdate,
2062: fnd_global.user_id,
2063: sysdate,
2064: fnd_global.login_id;
2058: cpd.inventory_item_id,
2059: cpd.organization_id,
2060: fnd_global.user_id,
2061: sysdate,
2062: fnd_global.user_id,
2063: sysdate,
2064: fnd_global.login_id;
2065:
2066: delete from csp_plan_details
2060: fnd_global.user_id,
2061: sysdate,
2062: fnd_global.user_id,
2063: sysdate,
2064: fnd_global.login_id;
2065:
2066: delete from csp_plan_details
2067: where (plan_detail_type,organization_id,inventory_item_id) in
2068: (select cpd.plan_detail_type,cpd.organization_id,cpd.inventory_item_id
2103: sum(decode(cpd.plan_detail_type,'8110',nvl(cpd.quantity*-1,0),'8210',nvl(cpd.quantity*-1,0),'2300',nvl(cpd.quantity,0),0))),0),
2104: min(cpd.plan_date),
2105: cpd.inventory_item_id,
2106: cpd.organization_id,
2107: fnd_global.user_id,
2108: sysdate,
2109: fnd_global.user_id,
2110: sysdate,
2111: fnd_global.login_id
2105: cpd.inventory_item_id,
2106: cpd.organization_id,
2107: fnd_global.user_id,
2108: sysdate,
2109: fnd_global.user_id,
2110: sysdate,
2111: fnd_global.login_id
2112: from csp_plan_details cpd,
2113: csp_plan_reorders cpr
2107: fnd_global.user_id,
2108: sysdate,
2109: fnd_global.user_id,
2110: sysdate,
2111: fnd_global.login_id
2112: from csp_plan_details cpd,
2113: csp_plan_reorders cpr
2114: where cpd.organization_id = l_organization_id
2115: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2124: cpr.excess_rop,
2125: cpr.excess_edq,
2126: cpd.inventory_item_id,
2127: cpd.organization_id,
2128: fnd_global.user_id,
2129: sysdate,
2130: fnd_global.user_id,
2131: sysdate,
2132: fnd_global.login_id;
2126: cpd.inventory_item_id,
2127: cpd.organization_id,
2128: fnd_global.user_id,
2129: sysdate,
2130: fnd_global.user_id,
2131: sysdate,
2132: fnd_global.login_id;
2133:
2134: delete from csp_plan_details
2128: fnd_global.user_id,
2129: sysdate,
2130: fnd_global.user_id,
2131: sysdate,
2132: fnd_global.login_id;
2133:
2134: delete from csp_plan_details
2135: where (plan_detail_type,organization_id,inventory_item_id) in
2136: (select cpd.plan_detail_type,cpd.organization_id,cpd.inventory_item_id
2178: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0)*nvl(min(cipp.excess_edq_multiple),nvl(l_edq_multiple,1)))),0),
2179: min(cpd.plan_date),
2180: cpd.inventory_item_id,
2181: cpd.organization_id,
2182: fnd_global.user_id,
2183: sysdate,
2184: fnd_global.user_id,
2185: sysdate,
2186: fnd_global.login_id
2180: cpd.inventory_item_id,
2181: cpd.organization_id,
2182: fnd_global.user_id,
2183: sysdate,
2184: fnd_global.user_id,
2185: sysdate,
2186: fnd_global.login_id
2187: from csp_plan_details cpd,
2188: csp_plan_reorders cpr,
2182: fnd_global.user_id,
2183: sysdate,
2184: fnd_global.user_id,
2185: sysdate,
2186: fnd_global.login_id
2187: from csp_plan_details cpd,
2188: csp_plan_reorders cpr,
2189: csp_item_pl_params cipp
2190: where cpd.organization_id = l_organization_id
2202: cpr.excess_rop,
2203: cpr.excess_edq,
2204: cpd.inventory_item_id,
2205: cpd.organization_id,
2206: fnd_global.user_id,
2207: sysdate,
2208: fnd_global.user_id,
2209: sysdate,
2210: fnd_global.login_id;
2204: cpd.inventory_item_id,
2205: cpd.organization_id,
2206: fnd_global.user_id,
2207: sysdate,
2208: fnd_global.user_id,
2209: sysdate,
2210: fnd_global.login_id;
2211:
2212: -- Delete repair excess on orders that have a value less than minimum value
2206: fnd_global.user_id,
2207: sysdate,
2208: fnd_global.user_id,
2209: sysdate,
2210: fnd_global.login_id;
2211:
2212: -- Delete repair excess on orders that have a value less than minimum value
2213: delete from csp_plan_details
2214: where (plan_detail_type,organization_id,inventory_item_id) in
2252: cpr.newbuy_safety_stock),
2253: 2,greatest(cpr.repair_rop,
2254: cpr.excess_rop,
2255: cpr.newbuy_rop)))*-1,
2256: fnd_global.user_id,
2257: sysdate,
2258: fnd_global.user_id,
2259: sysdate,
2260: fnd_global.login_id
2254: cpr.excess_rop,
2255: cpr.newbuy_rop)))*-1,
2256: fnd_global.user_id,
2257: sysdate,
2258: fnd_global.user_id,
2259: sysdate,
2260: fnd_global.login_id
2261: from csp_plan_details cpd,
2262: csp_plan_reorders cpr
2256: fnd_global.user_id,
2257: sysdate,
2258: fnd_global.user_id,
2259: sysdate,
2260: fnd_global.login_id
2261: from csp_plan_details cpd,
2262: csp_plan_reorders cpr
2263: where cpd.organization_id = l_organization_id
2264: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2307: select '8410',
2308: null,
2309: cpd.inventory_item_id,
2310: cpd.organization_id,
2311: -1001872,--fnd_global.user_id,
2312: sysdate,
2313: fnd_global.user_id,
2314: sysdate,
2315: fnd_global.login_id
2309: cpd.inventory_item_id,
2310: cpd.organization_id,
2311: -1001872,--fnd_global.user_id,
2312: sysdate,
2313: fnd_global.user_id,
2314: sysdate,
2315: fnd_global.login_id
2316: from csp_plan_details cpd,
2317: csp_plan_reorders cpr
2311: -1001872,--fnd_global.user_id,
2312: sysdate,
2313: fnd_global.user_id,
2314: sysdate,
2315: fnd_global.login_id
2316: from csp_plan_details cpd,
2317: csp_plan_reorders cpr
2318: where cpd.organization_id = l_organization_id
2319: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2355: cpd.plan_date,
2356: cpd.quantity - greatest(cpr.repair_rop + cpr.repair_edq * l_edq_multiple_out,
2357: cpr.excess_rop + cpr.excess_edq * l_edq_multiple_out,
2358: cpr.newbuy_rop + cpr.newbuy_edq * l_edq_multiple_out),
2359: fnd_global.user_id,
2360: sysdate,
2361: fnd_global.user_id,
2362: sysdate,
2363: fnd_global.login_id
2357: cpr.excess_rop + cpr.excess_edq * l_edq_multiple_out,
2358: cpr.newbuy_rop + cpr.newbuy_edq * l_edq_multiple_out),
2359: fnd_global.user_id,
2360: sysdate,
2361: fnd_global.user_id,
2362: sysdate,
2363: fnd_global.login_id
2364: from csp_plan_details cpd,
2365: csp_plan_reorders cpr,
2359: fnd_global.user_id,
2360: sysdate,
2361: fnd_global.user_id,
2362: sysdate,
2363: fnd_global.login_id
2364: from csp_plan_details cpd,
2365: csp_plan_reorders cpr,
2366: cst_item_costs cic,
2367: mtl_parameters mp
2425: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0)*nvl(l_edq_multiple,1))),0),
2426: min(cpd.plan_date),
2427: cpd.inventory_item_id,
2428: cpd.organization_id,
2429: fnd_global.user_id,
2430: sysdate,
2431: fnd_global.user_id,
2432: sysdate,
2433: fnd_global.login_id
2427: cpd.inventory_item_id,
2428: cpd.organization_id,
2429: fnd_global.user_id,
2430: sysdate,
2431: fnd_global.user_id,
2432: sysdate,
2433: fnd_global.login_id
2434: from csp_plan_details cpd,
2435: csp_plan_reorders cpr
2429: fnd_global.user_id,
2430: sysdate,
2431: fnd_global.user_id,
2432: sysdate,
2433: fnd_global.login_id
2434: from csp_plan_details cpd,
2435: csp_plan_reorders cpr
2436: where cpd.organization_id = l_organization_id
2437: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2446: cpr.excess_rop,
2447: cpr.excess_edq,
2448: cpd.inventory_item_id,
2449: cpd.organization_id,
2450: fnd_global.user_id,
2451: sysdate,
2452: fnd_global.user_id,
2453: sysdate,
2454: fnd_global.login_id;
2448: cpd.inventory_item_id,
2449: cpd.organization_id,
2450: fnd_global.user_id,
2451: sysdate,
2452: fnd_global.user_id,
2453: sysdate,
2454: fnd_global.login_id;
2455:
2456: -- Delete excess excess on orders that have a value less than minimum value
2450: fnd_global.user_id,
2451: sysdate,
2452: fnd_global.user_id,
2453: sysdate,
2454: fnd_global.login_id;
2455:
2456: -- Delete excess excess on orders that have a value less than minimum value
2457: delete from csp_plan_details
2458: where (plan_detail_type,organization_id,inventory_item_id) in
2505: nvl(cpr.excess_rop,0)+nvl(cpr.excess_edq,0))),
2506: min(trunc(sysdate)),
2507: mislv.inventory_item_id,
2508: l_organization_id,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.login_id
2507: mislv.inventory_item_id,
2508: l_organization_id,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.login_id
2514: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2515: csp_plan_reorders cpr,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.login_id
2514: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2515: csp_plan_reorders cpr,
2516: csp_plan_details cpd
2517: where mislv.organization_id = l_organization_id
2531: cpr.excess_rop,
2532: cpr.excess_edq,
2533: mislv.inventory_item_id,
2534: mislv.source_organization_id,
2535: fnd_global.user_id,
2536: sysdate,
2537: fnd_global.user_id,
2538: sysdate,
2539: fnd_global.login_id;
2533: mislv.inventory_item_id,
2534: mislv.source_organization_id,
2535: fnd_global.user_id,
2536: sysdate,
2537: fnd_global.user_id,
2538: sysdate,
2539: fnd_global.login_id;
2540: end;
2541:
2535: fnd_global.user_id,
2536: sysdate,
2537: fnd_global.user_id,
2538: sysdate,
2539: fnd_global.login_id;
2540: end;
2541:
2542: procedure repair is
2543: begin
2566: nvl(csp_validate_pub.get_available_qty,0),
2567: trunc(sysdate),
2568: mislv.inventory_item_id,
2569: cpd.organization_id,
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: sysdate,
2574: fnd_global.login_id
2568: mislv.inventory_item_id,
2569: cpd.organization_id,
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: sysdate,
2574: fnd_global.login_id
2575: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2576: csp_plan_details cpd
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: sysdate,
2574: fnd_global.login_id
2575: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2576: csp_plan_details cpd
2577: where mislv.organization_id = cpd.organization_id
2578: and mislv.assignment_set_id = l_defective_assignment_set_id
2610: trunc(sysdate),
2611: mri.related_item_id,
2612: cpd.organization_id,
2613: mri.inventory_item_id,
2614: fnd_global.user_id,
2615: sysdate,
2616: fnd_global.user_id,
2617: sysdate,
2618: fnd_global.login_id
2612: cpd.organization_id,
2613: mri.inventory_item_id,
2614: fnd_global.user_id,
2615: sysdate,
2616: fnd_global.user_id,
2617: sysdate,
2618: fnd_global.login_id
2619: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2620: csp_plan_details cpd,
2614: fnd_global.user_id,
2615: sysdate,
2616: fnd_global.user_id,
2617: sysdate,
2618: fnd_global.login_id
2619: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2620: csp_plan_details cpd,
2621: mtl_related_items mri,
2622: mtl_parameters mp
2884: greatest(trunc(l_plan_date),trunc(sysdate+1)),
2885: cr.inventory_item_id,
2886: l_organization_id,
2887: l_related_item_id,
2888: fnd_global.user_id,
2889: sysdate,
2890: fnd_global.user_id,
2891: sysdate,
2892: fnd_global.login_id
2886: l_organization_id,
2887: l_related_item_id,
2888: fnd_global.user_id,
2889: sysdate,
2890: fnd_global.user_id,
2891: sysdate,
2892: fnd_global.login_id
2893: from csp_plan_details cpd
2894: where cpd.organization_id = l_organization_id
2888: fnd_global.user_id,
2889: sysdate,
2890: fnd_global.user_id,
2891: sysdate,
2892: fnd_global.login_id
2893: from csp_plan_details cpd
2894: where cpd.organization_id = l_organization_id
2895: and cpd.inventory_item_id = cr.inventory_item_id
2896: and cpd.plan_detail_type = '1000'
2947: sum(cpd.quantity),
2948: trunc(plan_date),--trunc(trunc(sysdate) + (trunc((plan_date - trunc(sysdate))/l_period_size))*l_period_size),
2949: cpd.inventory_item_id,
2950: cpd.organization_id,
2951: fnd_global.user_id,
2952: sysdate,
2953: fnd_global.user_id,
2954: sysdate,
2955: fnd_global.login_id
2949: cpd.inventory_item_id,
2950: cpd.organization_id,
2951: fnd_global.user_id,
2952: sysdate,
2953: fnd_global.user_id,
2954: sysdate,
2955: fnd_global.login_id
2956: from csp_plan_details cpd
2957: where cpd.plan_detail_type in ('4110','4210','4310')
2951: fnd_global.user_id,
2952: sysdate,
2953: fnd_global.user_id,
2954: sysdate,
2955: fnd_global.login_id
2956: from csp_plan_details cpd
2957: where cpd.plan_detail_type in ('4110','4210','4310')
2958: and cpd.organization_id = l_organization_id
2959: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2981: sum(cpd.quantity),
2982: cpd.plan_date,
2983: cpd.inventory_item_id,
2984: cpd.organization_id,
2985: fnd_global.user_id,
2986: sysdate,
2987: fnd_global.user_id,
2988: sysdate,
2989: fnd_global.login_id
2983: cpd.inventory_item_id,
2984: cpd.organization_id,
2985: fnd_global.user_id,
2986: sysdate,
2987: fnd_global.user_id,
2988: sysdate,
2989: fnd_global.login_id
2990: from csp_plan_details cpd
2991: where cpd.plan_detail_type in ('4100','4200','4300')
2985: fnd_global.user_id,
2986: sysdate,
2987: fnd_global.user_id,
2988: sysdate,
2989: fnd_global.login_id
2990: from csp_plan_details cpd
2991: where cpd.plan_detail_type in ('4100','4200','4300')
2992: and cpd.organization_id = l_organization_id
2993: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
3019: min(cpd2.available_quantity)+sum(decode(cpd.plan_detail_type,'1000',cpd.quantity*-1,cpd.quantity)),
3020: trunc(max(sysdate + (i-1)*l_period_size)),
3021: cpd.inventory_item_id,
3022: cpd.organization_id,
3023: fnd_global.user_id,
3024: sysdate,
3025: fnd_global.user_id,
3026: sysdate,
3027: fnd_global.login_id
3021: cpd.inventory_item_id,
3022: cpd.organization_id,
3023: fnd_global.user_id,
3024: sysdate,
3025: fnd_global.user_id,
3026: sysdate,
3027: fnd_global.login_id
3028: from csp_plan_details cpd,csp_plan_details cpd2
3029: where cpd.plan_detail_type in ('1000','2000')
3023: fnd_global.user_id,
3024: sysdate,
3025: fnd_global.user_id,
3026: sysdate,
3027: fnd_global.login_id
3028: from csp_plan_details cpd,csp_plan_details cpd2
3029: where cpd.plan_detail_type in ('1000','2000')
3030: and cpd2.plan_detail_type = '1'
3031: and cpd.organization_id = cpd2.organization_id
3062: sum(nvl(cpd2.quantity,0)),
3063: cpd.plan_date,
3064: cpd.inventory_item_id,
3065: cpd.organization_id,
3066: fnd_global.user_id,
3067: sysdate,
3068: fnd_global.user_id,
3069: sysdate,
3070: fnd_global.login_id
3064: cpd.inventory_item_id,
3065: cpd.organization_id,
3066: fnd_global.user_id,
3067: sysdate,
3068: fnd_global.user_id,
3069: sysdate,
3070: fnd_global.login_id
3071: from csp_plan_details cpd,
3072: csp_plan_details cpd2
3066: fnd_global.user_id,
3067: sysdate,
3068: fnd_global.user_id,
3069: sysdate,
3070: fnd_global.login_id
3071: from csp_plan_details cpd,
3072: csp_plan_details cpd2
3073: where cpd.plan_detail_type = '3000'
3074: and cpd.organization_id = nvl(l_organization_id,cpd.organization_id)
3100: cpd.quantity,
3101: cpd.plan_date,
3102: cpd.inventory_item_id,
3103: cpd.organization_id,
3104: fnd_global.user_id,
3105: sysdate,
3106: fnd_global.user_id,
3107: sysdate,
3108: fnd_global.login_id
3102: cpd.inventory_item_id,
3103: cpd.organization_id,
3104: fnd_global.user_id,
3105: sysdate,
3106: fnd_global.user_id,
3107: sysdate,
3108: fnd_global.login_id
3109: from csp_plan_details cpd
3110: where cpd.plan_detail_type = '3000'
3104: fnd_global.user_id,
3105: sysdate,
3106: fnd_global.user_id,
3107: sysdate,
3108: fnd_global.login_id
3109: from csp_plan_details cpd
3110: where cpd.plan_detail_type = '3000'
3111: and cpd.organization_id = nvl(l_organization_id,cpd.organization_id)
3112: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
3155: msib.inventory_item_id,
3156: l_organization_id,
3157: l_orig_period_size,
3158: l_orig_forecast_periods,
3159: fnd_global.user_id,
3160: sysdate,
3161: fnd_global.user_id,
3162: sysdate,
3163: fnd_global.login_id
3157: l_orig_period_size,
3158: l_orig_forecast_periods,
3159: fnd_global.user_id,
3160: sysdate,
3161: fnd_global.user_id,
3162: sysdate,
3163: fnd_global.login_id
3164: from mtl_system_items_b msib,
3165: csp_plan_reorders cpr
3159: fnd_global.user_id,
3160: sysdate,
3161: fnd_global.user_id,
3162: sysdate,
3163: fnd_global.login_id
3164: from mtl_system_items_b msib,
3165: csp_plan_reorders cpr
3166: where msib.organization_id = l_organization_id
3167: and msib.inventory_item_id = nvl(l_inventory_item_id,msib.inventory_item_id)
3361: cpl.repair_lead_time,
3362: cpl.newbuy_lead_time,
3363: p_history_type,
3364: l_history_date,
3365: fnd_global.user_id,
3366: sysdate,
3367: fnd_global.user_id,
3368: sysdate,
3369: fnd_global.login_id
3363: p_history_type,
3364: l_history_date,
3365: fnd_global.user_id,
3366: sysdate,
3367: fnd_global.user_id,
3368: sysdate,
3369: fnd_global.login_id
3370: from csp_plan_details cpd,
3371: csp_planning_parameters cpp,
3365: fnd_global.user_id,
3366: sysdate,
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,