eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PLAN_DETAILS_PKG dependencies on STANDARD

Line 593: (nvl(csf.safety_factor,0) * b.standard_deviation + b.excess_total_req) excess_rop,

589: last_update_date,
590: last_update_login)
591: (select b.inventory_item_id,
592: b.organization_id,
593: (nvl(csf.safety_factor,0) * b.standard_deviation + b.excess_total_req) excess_rop,
594: (nvl(csf1.safety_factor, 0) * b.standard_deviation + b.repair_total_req) repair_rop,
595: (nvl(csf2.safety_factor, 0) * b.standard_deviation + b.newbuy_total_req) newbuy_rop,
596: b.excess_edq,
597: b.repair_edq,

Line 594: (nvl(csf1.safety_factor, 0) * b.standard_deviation + b.repair_total_req) repair_rop,

590: last_update_login)
591: (select b.inventory_item_id,
592: b.organization_id,
593: (nvl(csf.safety_factor,0) * b.standard_deviation + b.excess_total_req) excess_rop,
594: (nvl(csf1.safety_factor, 0) * b.standard_deviation + b.repair_total_req) repair_rop,
595: (nvl(csf2.safety_factor, 0) * b.standard_deviation + b.newbuy_total_req) newbuy_rop,
596: b.excess_edq,
597: b.repair_edq,
598: b.newbuy_edq,

Line 595: (nvl(csf2.safety_factor, 0) * b.standard_deviation + b.newbuy_total_req) newbuy_rop,

591: (select b.inventory_item_id,
592: b.organization_id,
593: (nvl(csf.safety_factor,0) * b.standard_deviation + b.excess_total_req) excess_rop,
594: (nvl(csf1.safety_factor, 0) * b.standard_deviation + b.repair_total_req) repair_rop,
595: (nvl(csf2.safety_factor, 0) * b.standard_deviation + b.newbuy_total_req) newbuy_rop,
596: b.excess_edq,
597: b.repair_edq,
598: b.newbuy_edq,
599: (nvl(csf.safety_factor,0) * nvl(b.standard_deviation, 0)) excess_safety_stock,

Line 599: (nvl(csf.safety_factor,0) * nvl(b.standard_deviation, 0)) excess_safety_stock,

595: (nvl(csf2.safety_factor, 0) * b.standard_deviation + b.newbuy_total_req) newbuy_rop,
596: b.excess_edq,
597: b.repair_edq,
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,

Line 600: (nvl(csf1.safety_factor,0) * nvl(b.standard_deviation, 0)) repair_safety_stock,

596: b.excess_edq,
597: b.repair_edq,
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,

Line 601: (nvl(csf2.safety_factor,0) * nvl(b.standard_deviation, 0)) newbuy_safety_stock,

597: b.repair_edq,
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,

Line 627: ,nvl(cuh.standard_deviation, 0) standard_deviation

623: , a.organization_id
624: , nvl(nvl(cipp.excess_service_level, cpp1.excess_service_level), cpp1.service_level) excess_service_level
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,