[Home] [Help]
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
98: and cpl.organization_id = cpd.organization_id
99: and cpl.inventory_item_id = cpd.inventory_item_id
125:
126: cursor c_nb_int_ext(p_organization_id number, p_supplied_item_id number) is
127: select decode(nvl(msi.source_type,mp.source_type),1,'INTERNAL','EXTERNAL')
128: from mtl_system_items msi,
129: mtl_parameters mp
130: where mp.organization_id = msi.organization_id
131: and msi.organization_id = p_organization_id
132: and msi.inventory_item_id = p_supplied_item_id;
133:
150: lpad(to_char(round(avg(
151: nvl(cuh.tracking_signal,0)),2)),11,' ') statistics
152: from csp_plan_details cpd,
153: cst_item_costs cic,
154: mtl_parameters mp,
155: csp_usage_headers cuh
156: where cic.organization_id = cpd.organization_id
157: and cic.inventory_item_id = cpd.inventory_item_id
158: and cpd.plan_detail_type in ('8610','8620','8630')
626: ,nvl(nvl(cipp.newbuy_service_level, cpp1.newbuy_service_level), cpp1.service_level) newbuy_service_level
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 *
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
1901: from csp_plan_details cpd,
1902: mtl_parameters mp,
1903: cst_item_costs cict
1904: where cpd.plan_detail_type = '8110'
1905: and mp.organization_id = cict.organization_id
1906: and cict.inventory_item_id = cpd.inventory_item_id
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
2069: from csp_plan_details cpd,
2070: mtl_parameters mp,
2071: cst_item_costs cict
2072: where cpd.plan_detail_type in ('8210','8220')
2073: and mp.organization_id = cict.organization_id
2074: and cict.inventory_item_id = cpd.inventory_item_id
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
2137: from csp_plan_details cpd,
2138: mtl_parameters mp,
2139: cst_item_costs cict
2140: where cpd.plan_detail_type = '8310'
2141: and mp.organization_id = cict.organization_id
2142: and cict.inventory_item_id = cpd.inventory_item_id
2213: delete from csp_plan_details
2214: where (plan_detail_type,organization_id,inventory_item_id) in
2215: (select cpd.plan_detail_type,cpd.organization_id,cpd.inventory_item_id
2216: from csp_plan_details cpd,
2217: mtl_parameters mp,
2218: cst_item_costs cict
2219: where cpd.plan_detail_type = '8120'
2220: and mp.organization_id = cict.organization_id
2221: and cict.inventory_item_id = cpd.inventory_item_id
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
2368: where cpd.organization_id = l_organization_id
2369: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2370: and cpd.plan_detail_type = l_onhand_type_out
2371: and cpd.quantity > greatest(cpr.repair_rop + cpr.repair_edq * l_edq_multiple_out,
2457: delete from csp_plan_details
2458: where (plan_detail_type,organization_id,inventory_item_id) in
2459: (select cpd.plan_detail_type,cpd.organization_id,cpd.inventory_item_id
2460: from csp_plan_details cpd,
2461: mtl_parameters mp,
2462: cst_item_costs cict
2463: where cpd.plan_detail_type = '8130'
2464: and mp.organization_id = cict.organization_id
2465: and cict.inventory_item_id = cpd.inventory_item_id
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
2623: where mislv.organization_id = cpd.organization_id
2624: and mislv.assignment_set_id = l_defective_assignment_set_id
2625: and mislv.inventory_item_id = cpd.inventory_item_id
2626: and mislv.sourcing_level not in (2,9)
2748: select nvl(msib.source_organization_id,mp.source_organization_id),
2749: cpr.newbuy_edq,
2750: null
2751: from mtl_system_items_b msib,
2752: mtl_parameters mp,
2753: csp_plan_reorders cpr
2754: where msib.organization_id = l_organization_id
2755: and msib.inventory_item_id = p_inventory_item_id
2756: and mp.organization_id = msib.organization_id