DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on CSI_ITEM_INSTANCES

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)