DBA Data[Home] [Help]

APPS.AHL_FLEET_UTIL_HISTORY_PVT dependencies on FND_NEW_MESSAGES

Line 164: FROM fnd_new_messages

160: COUNT(*) unit_per_day
161: FROM
162: (SELECT rownum,
163: (p_start_date + rownum - 1) ddate
164: FROM fnd_new_messages
165: WHERE rownum <= (p_end_date - p_start_date + 1)
166: ) dtab,
167: ahl_fleet_unit_assocs fleet
168: WHERE fleet.fleet_header_id = p_fleet_header_id

Line 886: FROM fnd_new_messages

882: COUNT(*) unit_per_day
883: FROM
884: (SELECT rownum,
885: (p_start_date + rownum - 1) ddate
886: FROM fnd_new_messages
887: WHERE rownum <= (p_end_date - p_start_date + 1)
888: ) dtab,
889: ahl_fleet_unit_assocs fleet
890: WHERE fleet.fleet_header_id = p_fleet_header_id