DBA Data[Home] [Help]

APPS.CSP_SUPPLY_DEMAND_PVT dependencies on CSP_REP_HIERARCHIES

Line 1359: csp_rep_hierarchies crh

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

Line 1406: csp_rep_hierarchies crh

1402: sum(nvl(crsdt.move_orders_in,0)) move_orders_in,
1403: sum(nvl(crsdt.move_orders_out,0)) move_orders_out,
1404: sum(nvl(crsdt.work_orders,0)) work_orders
1405: from csp_sup_dem_rh_temp crsdt,
1406: csp_rep_hierarchies crh
1407: where crh.hierarchy_node_id = crsdt.hierarchy_node_id
1408: group by
1409: crsdt.inventory_item_id,
1410: crsdt.hierarchy_node_id,