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_SUPPLY_DEMAND_PVT dependencies on CSP_SUP_DEM_RH_TEMP

Line 1288: insert into csp_sup_dem_rh_temp(

1284: l_level number := 1;
1285: begin
1286: l_level := 1;
1287: --subinventories to parent
1288: insert into csp_sup_dem_rh_temp(
1289: level_id,
1290: organization_id,
1291: inventory_item_id,
1292: hierarchy_node_id,

Line 1326: insert into csp_sup_dem_rh_temp(

1322: inventory_item_id,
1323: hierarchy_node_id;
1324: loop
1325: -- node to parent
1326: insert into csp_sup_dem_rh_temp(
1327: level_id,
1328: organization_id,
1329: inventory_item_id,
1330: hierarchy_node_id,

Line 1357: from csp_sup_dem_rh_temp ctsd,

1353: sum(nvl(interorg_transf_out,0)),
1354: sum(nvl(move_orders_in,0)),
1355: sum(nvl(move_orders_out,0)),
1356: sum(nvl(work_orders,0))
1357: from csp_sup_dem_rh_temp ctsd,
1358: csp_rep_hierarchies crh
1359: where level_id = l_level
1360: and crh.hierarchy_node_id = ctsd.hierarchy_node_id
1361: and crh.parent_node_id > 0