APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_FORECAST_RULES_B

Line 58: CSP_FORECAST_RULES_B cfrb

54: Select HISTORY_PERIODS,
55: PERIOD_SIZE,
56: cfrb.FORECAST_RULE_ID
57: From CSP_PLANNING_PARAMETERS cpp,
58: CSP_FORECAST_RULES_B cfrb
59: Where cpp.ORGANIZATION_ID IS NULL
60: And cpp.SECONDARY_INVENTORY IS NULL
61: And cpp.FORECAST_RULE_ID = cfrb.FORECAST_RULE_ID;
62:

Line 750: csp_forecast_rules_b cfrb,

746: cuh_fcst.quantity - sum(cuh_usg.quantity) diff,
747: cfrb.forecast_periods
748: from csp_usage_histories cuh_fcst,
749: csp_planning_parameters cpp,
750: csp_forecast_rules_b cfrb,
751: csp_usage_histories cuh_usg
752: where cuh_fcst.history_data_type = 5
753: and cuh_fcst.period_start_date between (trunc(sysdate) - cfrb.forecast_periods * cfrb.period_size * cfrb.tracking_signal_cycle) and trunc(sysdate)
754: and cuh_fcst.organization_id = cpp.organization_id

Line 795: csp_forecast_rules_b cfrb,

791: cuh_fcst.quantity - sum(cuh_usg.quantity) diff,
792: cfrb.forecast_periods
793: from csp_usage_histories cuh_fcst,
794: csp_planning_parameters cpp,
795: csp_forecast_rules_b cfrb,
796: csp_usage_org_mv cuh_usg
797: where cuh_fcst.history_data_type = 5
798: and cuh_fcst.period_start_date between (trunc(sysdate) - cfrb.forecast_periods * cfrb.period_size * cfrb.tracking_signal_cycle) and trunc(sysdate)
799: and cpp.organization_id = cuh_fcst.organization_id

Line 1266: CSP_FORECAST_RULES_B cfrb

1262: cpp.RECOMMEND_METHOD
1263: From CSP_PLANNING_PARAMETERS cpp,
1264: CSP_USAGE_HISTORIES cuh,
1265: CSP_SUPERSEDE_ITEMS csi,
1266: CSP_FORECAST_RULES_B cfrb
1267: Where cpp.level_id like P_Level_Id || '%'
1268: And cpp.node_type = 'SUBINVENTORY'
1269: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1270: And cuh.organization_id = cpp.organization_id

Line 1342: CSP_FORECAST_RULES_B cfrb

1338: cpp.RECOMMEND_METHOD
1339: From CSP_PLANNING_PARAMETERS cpp,
1340: CSP_USAGE_ORG_MV cuom,
1341: CSP_SUPERSEDE_ITEMS csi,
1342: CSP_FORECAST_RULES_B cfrb
1343: Where cpp.level_id like P_Level_Id || '%'
1344: And cpp.node_type = 'ORGANIZATION_WH'
1345: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1346: And (cuom.PERIOD_START_DATE BETWEEN (trunc(sysdate) - cfrb.forecast_periods

Line 1443: FROM csp_forecast_rules_b;

1439: --
1440: IF p_reason_code = 'TS' Then
1441: SELECT nvl(max(tracking_signal_cycle),0)
1442: INTO l_max_ts_cycle
1443: FROM csp_forecast_rules_b;
1444: l_ts_cycle := 1;
1445: Else
1446: l_ts_cycle := 0;
1447: l_max_ts_cycle := 0;

Line 2316: CSP_FORECAST_RULES_B cfrb

2312:
2313: Cursor c_Period_Size Is
2314: Select MAX(HISTORY_PERIODS * PERIOD_SIZE) PERIOD_SIZE
2315: From CSP_PLANNING_PARAMETERS cpp,
2316: CSP_FORECAST_RULES_B cfrb
2317: Where cpp.FORECAST_RULE_ID = cfrb.FORECAST_RULE_ID;
2318:
2319:
2320: l_api_name constant varchar2(30) := 'Create_Supply_Chain';