APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_FORECAST_RULES_B

Line 687: csp_forecast_rules_b cfrb

683: cpd.organization_id
684: from csp_plan_details cpd,
685: csp_plan_leadtimes cpl,
686: csp_planning_parameters cpp,
687: csp_forecast_rules_b cfrb
688: where cpd.organization_id = p_organization_id
689: and cpd.inventory_item_id = nvl(p_inventory_item_id, cpd.inventory_item_id)
690: and cpd.plan_detail_type = 1000
691: and cpd.plan_Date between trunc(sysdate)

Line 751: csp_forecast_rules_b cfrb,

747: sysdate,
748: fnd_global.login_id
749: from csp_plan_details cpd,
750: csp_planning_parameters cpp,
751: csp_forecast_rules_b cfrb,
752: mtl_material_transactions mmt,
753: csp_usg_transaction_types cutt
754: where cpd.plan_detail_type in ('9002','9003')
755: and cpd.organization_id = l_organization_id

Line 803: from csp_forecast_rules_b cfrb,

799: max(a.history_periods),
800: max(a.period_size)
801: from csp_plan_details cpd,
802: (select round(max(cfrb.history_periods*cfrb.period_size)/max(cfrb.period_size)+0.499999) history_periods,max(cfrb.period_size) period_size,cpd.organization_id,cpd.inventory_item_id
803: from csp_forecast_rules_b cfrb,
804: csp_planning_parameters cpp,
805: csp_plan_details cpd
806: where cfrb.forecast_rule_id = cpp.forecast_rule_id
807: and cpd.plan_detail_type in ('6100','6200')

Line 850: csp_forecast_rules_b cfrb

846: beta,
847: nvl(cpl.repair_lead_time,0) repair_lead_time
848: from csp_plan_details cpd,
849: csp_plan_leadtimes cpl,
850: csp_forecast_rules_b cfrb
851: where cpd.organization_id = l_organization_id
852: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
853: and cpd.plan_detail_type = '6000'
854: and cfrb.forecast_rule_id = l_forecast_rule_id

Line 896: csp_forecast_rules_b cfrb,

892: (select round(sum(cpd2.quantity* l_period_size /cfrb.period_size/cfrb.history_periods)) quantity,
893: cpd2.organization_id organization_id,
894: cpd2.inventory_item_id inventory_item_id
895: from csp_plan_details cpd2,
896: csp_forecast_rules_b cfrb,
897: csp_planning_parameters cpp
898: where cpd2.plan_detail_type = '6000'
899: and cpp.organization_id = cpd2.source_organization_id
900: and cfrb.forecast_rule_id = cpp.forecast_rule_id

Line 957: csp_forecast_rules_b cfrb,

953: 12,weighted_avg_period12))*l_period_size/l_forecast_period_size) quantity,
954: cpd2.organization_id organization_id,
955: cpd2.inventory_item_id inventory_item_id
956: from csp_plan_details cpd2,
957: csp_forecast_rules_b cfrb,
958: csp_planning_parameters cpp
959: where cpd2.plan_detail_type = '6000'
960: and cpp.organization_id = cpd2.source_organization_id
961: and cfrb.forecast_rule_id = cpp.forecast_rule_id

Line 1178: csp_forecast_rules_b cfrb

1174: fnd_global.user_id,
1175: sysdate,
1176: fnd_global.login_id
1177: from csp_usage_histories cuh,
1178: csp_forecast_rules_b cfrb
1179: where history_data_type = 2
1180: and period_start_date between decode(l_forecast_method,4,trunc(sysdate) + (l_counter - 1) * l_period_size,period_start_date)
1181: and decode(l_forecast_method,4,trunc(sysdate) + (l_counter - 1) * l_period_size + (l_period_size - 1),trunc(sysdate) + l_period_size * l_forecast_periods - 1)
1182: and organization_id = l_organization_id

Line 3459: from csp_forecast_rules_b cfrb,

3455: p_inventory_item_id in number default null) is
3456: cursor c_forecast_rules is
3457: select cfrb.forecast_periods,
3458: cfrb.period_size
3459: from csp_forecast_rules_b cfrb,
3460: csp_planning_parameters cpp
3461: where cfrb.forecast_rule_id = cpp.forecast_rule_id
3462: and cpp.organization_id = p_organization_id
3463: and cpp.organization_type = 'W';

Line 3513: from csp_forecast_rules_b cfrb,

3509: cpp.edq_multiple,
3510: cpp.level_id,
3511: cpp.reschedule_rule_id,
3512: cpp.minimum_value
3513: from csp_forecast_rules_b cfrb,
3514: csp_planning_parameters cpp
3515: where cfrb.forecast_rule_id = cpp.forecast_rule_id
3516: and cpp.organization_id = nvl(l_organization_id,cpp.organization_id)
3517: and cpp.organization_type = 'W';