eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_USAGE_HISTORIES

Line 265: DELETE FROM csp_usage_histories

261: Where cpp.level_id like p_Level_Id || '%' And cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY'));
262: End If;
263: commit;
264: If p_Level_Id = '1' Then
265: DELETE FROM csp_usage_histories
266: WHERE history_data_type IN (2,5);
267: Else
268: Delete from csp_usage_histories cuh
269: Where history_data_type in (2,5)

Line 268: Delete from csp_usage_histories cuh

264: If p_Level_Id = '1' Then
265: DELETE FROM csp_usage_histories
266: WHERE history_data_type IN (2,5);
267: Else
268: Delete from csp_usage_histories cuh
269: Where history_data_type in (2,5)
270: And (cuh.organization_id,cuh.subinventory_code) in
271: (select cpp.organization_id ,nvl(cpp.secondary_inventory,'-')
272: from csp_planning_parameters cpp

Line 748: from csp_usage_histories cuh_fcst,

744: cuh_fcst.organization_id,
745: cuh_fcst.subinventory_code,
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

Line 751: csp_usage_histories cuh_usg

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
755: and cuh_fcst.subinventory_code = cpp.secondary_inventory

Line 793: from csp_usage_histories cuh_fcst,

789: select cuh_fcst.inventory_item_id,
790: cuh_fcst.organization_id,
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

Line 967: -- Delete from Csp_Usage_Histories

963: -- Delete from Csp_Usage_Headers
964: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HEADERS';
965:
966:
967: -- Delete from Csp_Usage_Histories
968: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HISTORIES';
969:
970: -- Delete from Csp_Supply_Chain
971: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN';

Line 968: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HISTORIES';

964: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HEADERS';
965:
966:
967: -- Delete from Csp_Usage_Histories
968: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HISTORIES';
969:
970: -- Delete from Csp_Supply_Chain
971: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN';
972:

Line 1264: CSP_USAGE_HISTORIES cuh,

1260: cfrb.WEIGHTED_AVG_PERIOD11,
1261: cfrb.WEIGHTED_AVG_PERIOD12,
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'

Line 1510: INSERT INTO CSP_USAGE_HISTORIES (Usage_Id,

1506: X_Forecast_Quantities =>l_Forecast_Qty_Tbl);
1507:
1508: End If;
1509: FOR l_Index in 1..l_Forecast_Qty_Tbl.COUNT LOOP
1510: INSERT INTO CSP_USAGE_HISTORIES (Usage_Id,
1511: created_by,
1512: creation_date,
1513: last_updated_by,
1514: last_update_date,

Line 1522: VALUES ( csp_usage_histories_s1.nextval,

1518: period_type,
1519: period_start_date,
1520: quantity,
1521: history_data_type)
1522: VALUES ( csp_usage_histories_s1.nextval,
1523: fnd_global.user_id, sysdate,
1524: fnd_global.user_id,sysdate,
1525: l_Prev_Rec.Inventory_Item_id,
1526: l_Prev_Rec.Organization_id,

Line 2607: insert into csp_usage_histories(

2603: --
2604: -- API body
2605: --
2606: -- Create Usage History for Engineering subinventories
2607: insert into csp_usage_histories(
2608: organization_id,
2609: subinventory_code,
2610: inventory_item_id,
2611: period_start_date,

Line 2653: insert into csp_usage_histories(

2649:
2650: -- Rollup Usage History through Supply Chain
2651: loop
2652: l_supply_level := l_supply_level + 1;
2653: insert into csp_usage_histories(
2654: organization_id,
2655: subinventory_code,
2656: inventory_item_id,
2657: period_start_date,

Line 2680: csp_usage_histories cuh

2676: sysdate,
2677: fnd_global.user_id,
2678: sysdate
2679: from csp_supply_chain csc,
2680: csp_usage_histories cuh
2681: where cuh.history_data_type = 1
2682: and cuh.period_start_date > G_LAST_RUN_DATE
2683: and cuh.organization_id = csc.organization_id
2684: and cuh.subinventory_code = csc.secondary_inventory