DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_USAGE_HEADERS

Line 96: csp_usage_headers cuh

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
100: and cpd.plan_detail_type in ('4110','4210','4310')

Line 155: csp_usage_headers cuh

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')
159: and mp.organization_id = cpd.organization_id

Line 628: from csp_usage_headers cuh,

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,
632: csp_item_pl_params cipp,