DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 417: FROM ahl_unit_config_headers

413:
414: CURSOR is_unit_valid(c_unit_config_header_id NUMBER)
415: IS
416: SELECT 'X'
417: FROM ahl_unit_config_headers
418: WHERE unit_config_header_id = c_unit_config_header_id;
419:
420: CURSOR get_fleet_unit_asso(c_fleet_header_id NUMBER, c_unit_config_header_id NUMBER)
421: IS

Line 441: FROM ahl_unit_config_headers uch, csi_item_instances csi

437: CURSOR get_item_instance_det(c_unit_config_header_id NUMBER)
438: IS
439: SELECT uch.csi_item_instance_id, csi.instance_number, csi.serial_number,
440: csi.inventory_item_id , uch.name, csi.owner_party_id
441: FROM ahl_unit_config_headers uch, csi_item_instances csi
442: WHERE uch.unit_config_header_id = c_unit_config_header_id
443: AND uch.csi_item_instance_id = csi.instance_id;
444:
445: CURSOR get_reconfig_mrs(c_fleet_header_id NUMBER, c_src_operations_type_code VARCHAR2)