DBA Data[Home] [Help]

APPS.AHL_PC_NODE_PVT dependencies on AHL_UTILIZATION_FORECAST_V

Line 576: FROM ahl_utilization_forecast_v

572: BEGIN
573:
574: SELECT distinct 'X'
575: INTO l_exist
576: FROM ahl_utilization_forecast_v
577: WHERE pc_node_id IN
578: (
579: SELECT pc_node_id
580: FROM ahl_pc_nodes_b

Line 601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

597: BEGIN
598:
599: SELECT distinct 'X'
600: INTO l_exist
601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
602: WHERE uf.unit_config_header_id = assos.unit_item_id and
603: assos.pc_node_id = node.pc_node_id and
604: node.pc_node_id IN (
605: SELECT pc_node_id

Line 625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

621: BEGIN
622:
623: SELECT distinct 'X'
624: INTO l_exist
625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
626: WHERE uf.inventory_item_id = assos.unit_item_id and
627: uf.inventory_org_id = assos.inventory_org_id and
628: assos.pc_node_id = node.pc_node_id and
629: node.pc_node_id IN (