[Home] [Help]
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
98: and cpl.organization_id = cpd.organization_id
149: lpad(to_char(sum(cpd.quantity)),15,' ') ||
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
625: ,nvl(nvl(cipp.repair_service_level, cpp1.repair_service_level), cpp1.service_level) repair_service_level
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 *
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
1907: and cict.organization_id = cpd.organization_id
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
2075: and cict.organization_id = cpd.organization_id
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
2143: and cict.organization_id = cpd.organization_id
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
2222: and cict.organization_id = cpd.organization_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
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
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
2466: and cict.organization_id = cpd.organization_id