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_orgs 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 1286: CSP_FORECAST_RULES_B cfrb

1282: cpp.RECOMMEND_METHOD
1283: From CSP_PLANNING_PARAMETERS cpp,
1284: CSP_USAGE_HISTORIES cuh,
1285: CSP_SUPERSEDE_ITEMS csi,
1286: CSP_FORECAST_RULES_B cfrb
1287: Where cpp.level_id like P_Level_Id || '%'
1288: And cpp.node_type = 'SUBINVENTORY'
1289: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1290: And cuh.organization_id = cpp.organization_id

Line 1362: CSP_FORECAST_RULES_B cfrb

1358: cpp.RECOMMEND_METHOD
1359: From CSP_PLANNING_PARAMETERS cpp,
1360: CSP_USAGE_ORGS cuom,
1361: CSP_SUPERSEDE_ITEMS csi,
1362: CSP_FORECAST_RULES_B cfrb
1363: Where cpp.level_id like P_Level_Id || '%'
1364: And cpp.node_type = 'ORGANIZATION_WH'
1365: And cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM','PNORM','TNORM')
1366: And (cuom.PERIOD_START_DATE BETWEEN (trunc(sysdate) - cfrb.forecast_periods

Line 1463: FROM csp_forecast_rules_b;

1459: --
1460: IF p_reason_code = 'TS' Then
1461: SELECT nvl(max(tracking_signal_cycle),0)
1462: INTO l_max_ts_cycle
1463: FROM csp_forecast_rules_b;
1464: l_ts_cycle := 1;
1465: Else
1466: l_ts_cycle := 0;
1467: l_max_ts_cycle := 0;

Line 2336: CSP_FORECAST_RULES_B cfrb

2332:
2333: Cursor c_Period_Size Is
2334: Select MAX(HISTORY_PERIODS * PERIOD_SIZE) PERIOD_SIZE
2335: From CSP_PLANNING_PARAMETERS cpp,
2336: CSP_FORECAST_RULES_B cfrb
2337: Where cpp.FORECAST_RULE_ID = cfrb.FORECAST_RULE_ID;
2338:
2339:
2340: l_api_name constant varchar2(30) := 'Create_Supply_Chain';