APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_ITEM_PL_PARAMS

Line 632: csp_item_pl_params cipp,

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 *
635: floor(cpl.Excess_Lead_Time/cfrb.period_size))), 0, cpd.quantity, 0))) +
636: sum(decode(sign(cpl.Excess_lead_time - cfrb.period_size), -1,

Line 1875: csp_item_pl_params cipp

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
1877: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
1878: and cpd.plan_detail_type in ('1','2000','2300')
1879: and cpd.quantity > 0

Line 2189: csp_item_pl_params cipp

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
2191: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
2192: and cpd.plan_detail_type in ('1','2000','2200','8110')
2193: and cpd.quantity > 0

Line 3374: csp_item_pl_params cipp

3370: from csp_plan_details cpd,
3371: csp_planning_parameters cpp,
3372: csp_plan_reorders cpr,
3373: csp_plan_leadtimes cpl,
3374: csp_item_pl_params cipp
3375: where cpd.plan_detail_type = '1'
3376: and cpd.organization_id = p_organization_id
3377: and cpd.inventory_item_id = nvl(p_inventory_item_id,cpd.inventory_item_id)
3378: and cpp.organization_id = cpd.organization_id